tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 710330d1608843880-if-statement-formula-help-excelhelpexample-etaf2
Sheet: Sheet1

 |  |  | NUMBER OF times in A |  | avg | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Jrue Holiday | 21.5 |  |  | Jrue Holiday | 19.1311475409836
[NAME] | 18.5 |  |  | [NAME] | 23.82258064516129
Derrick Favors | 16.5 |  |  | Derrick Favors | 9
JJ Redick | 9.5 |  |  | JJ Redick | 15.28333333333333
Derrick Favors | 12.1 |  |  | [NAME] | 11.82539682539683
[NAME] | 13.2 |  |  | [NAME] | 10.09230769230769
Jahlil Okafor | 14.1 |  |  | Jahlil Okafor | 8.1
Derrick Favors | 15.9
Nickeil Alexander-Walker | 9.8 |  |  |  |  |  | JUST RETURNING THE NUMBER
[NAME] | 13.5
Derrick Favors | 9.5
[NAME] | 7 |  |  | I have a set of names in column E with their avg points column F. In Column A and B there is a list of names with a points number next to them. I am trying to find a formula to enter in cell G2 that if a name in column A matches a name in Column E, it will take the points in column B and subtract it by the avg points in column F. I am able to get a standard IF statement that will do that but it will only pull the very first result where in reality that name is listed several times throughout the list. So, I either need a formula that will post it each time in Cells G2, H2, I2, etc or a formula that can subtract the points each time in column B to the name that looksup column F and takes the overall average of that?
OG Anunoby | 8.3
Derrick Favors | 4.9
[NAME] | 6.5
[NAME] | 21.5
Derrick Favors | 19.5
Derrick Favors | 19.1
OG Anunoby | 8.9
JJ Redick | 7.9
Derrick Favors | 8.6
Jahlil Okafor | 5.6
Derrick Favors | 9.8
Jahlil Okafor | 12.6
Derrick Favors | 13.1
Derrick Favors | 16.1
[NAME] | 14.5
Derrick Favors | 1
Derrick Favors | 2
Derrick Favors | 3
Spreadsheet: 82112d1282149076-hidden-format-akka02_demo
Sheet: new spreadsheet

year
1901 |  | concatenation
1902 |  | 1902 hello again
1903
1904
1905
1906 |  | 1906 hello again
1907
1908
1909
1910
1911
1912 |  | 1912 hello again
 |  | ▲▲▲▲▲
 |  | it works
format cell = standard
this spreadsheet is 100% excel 2003
Spreadsheet: aad17451-909d-413f-9fb8-6f8efe41099d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Emerging Defensive Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | MSCI Emerging Markets
 | Date | AZEIX | AZENX | Index
* | 2012-07-31 00:00:00 | 0.007000000000000117 | 0.007000000000000117 | 0.01975827895914706
 | 2012-08-31 00:00:00 | 0.01588877855014892 | 0.0148957298907646 | -0.003330280135328989
 | 2012-09-30 00:00:00 | 0.02443792766373409 | 0.02544031311154593 | 0.06034189668727818
 | 2012-10-31 00:00:00 | -0.007633587786259555 | -0.007633587786259555 | -0.006072053025255264
 | 2012-11-30 00:00:00 | 0.004807692307692291 | 0.003846153846153832 | 0.01269714856016657
 | 2012-12-31 00:00:00 | 0.0563846298031867 | 0.05669482292249661 | 0.04889502762430942
 | 2013-01-31 00:00:00 | -0.01282051282051277 | -0.01279707495429605 | 0.0137875563211356
 | 2013-02-28 00:00:00 | -0.007421150278293154 | -0.008333333333333304 | -0.01256324921947771
 | 2013-03-31 00:00:00 | -0.002803738317756932 | -0.002801120448179373 | -0.01939750183688471
 | 2013-04-30 00:00:00 | 0.02530459231490156 | 0.02528089887640439 | 0.00976975099461952
 | 2013-05-31 00:00:00 | -0.0356 | -0.0356 | -0.0257
 | 2013-06-30 00:00:00 | -0.03981042654028422 | -0.03977272727272729 | -0.0636580272693773
 | 2013-07-31 00:00:00 | -0.009871668311944859 | -0.01084812623274178 | 0.0104476593779681
 | 2013-08-31 00:00:00 | -0.03988035892323027 | -0.03988035892323016 | -0.0171764644786041
 | 2013-09-30 00:00:00 | 0.0664589823 | 0.0654205607 | 0.065
 | 2013-10-31 00:00:00 | 0.0360272639 | 0.037037037 | 0.0485836688
 | 2013-11-30 00:00:00 | -0.02819548872180466 | -0.02913533834586468 | -0.01462252545516485
 | 2013-12-31 00:00:00 | -0.012342557 | -0.012175622 | -0.01445779
 | 2014-01-31 00:00:00 | -0.07905138339920947 | -0.07996051332675236 | -0.06493528639394286
 | * partial month return, inception date 7/9/2012
 | Emerging Defensive Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | MSCI Emerging Markets
 | January 31, 2014 | AZEIX | AZENX | Index
 | 1 Year | -0.1275440306008176 | -0.13071382477744 | -0.1016504521930622
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.04922444973429951 | -0.05328494238870252 | 0.03622305600364673
 | Since Inception Annualized Return | -0.03175153791002794 | -0.03439686503975492 | 0.02300598092259709
 | Since Inception Annualized Monthly Volatility | 0.1222046570504888 | 0.1227129418304025 | 0.1256343800610966
 | Quarter-end Returns as of | Class I | Class N | MSCI Emerging Markets
 | December 31, 2013 | AZEIX | AZENX | Index
 | 1 Year | -0.06480055354542347 | -0.06725540880368719 | -0.02601864956205169
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.03238718548164043 | 0.02899394137365285 | 0.1081832529082127
 | Since Inception Annualized Return | 0.0217780662049234 | 0.01950684334442898 | 0.07189964073582544
Spreadsheet: 870701d1717166549-create-summary-page-using-formula-from-multiple-sheets-data-are-in-different-columns-on-ea-sample-file
Sheet: Overall summary

Name | Price A | Price B | Price C
Brand1 | 77 | 71 | 233
Brand2 | 57 | 73 | 97
Brand3 | 62 | 72 | 132
Brand4 | 124 | 125 | 395
Brand5 | 104 | 92 | 406
Brand6 | 48 | 44 | 155
Brand7 | 80 | 85 | 214
Spreadsheet: 61704d1262635370-sort-or-filter-data-lottery
Sheet: data

Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | bonus
2025-09-01 00:00:00 | 5 | 17 | 19 | 25 | 31 | 38 | 46 | 4
1930-10-01 00:00:00 | 9 | 10 | 14 | 17 | 18 | 19 | 46 | 6
2023-10-01 00:00:00 | 7 | 10 | 12 | 23 | 25 | 36 | 18 | 4
2016-10-01 00:00:00 | 10 | 18 | 20 | 31 | 35 | 44 | 29 | 4
2009-10-01 00:00:00 | 15 | 25 | 38 | 42 | 46 | 47 | 26 | 5
2002-10-01 00:00:00 | 27 | 28 | 29 | 31 | 32 | 35 | 11 | 8
2027-11-01 00:00:00 | 11 | 15 | 24 | 26 | 37 | 38 | 43 | 17
2020-11-01 00:00:00 | 2 | 8 | 28 | 30 | 36 | 39 | 42 | 24
2013-11-01 00:00:00 | 8 | 18 | 27 | 28 | 38 | 41 | 48 | 36
2006-11-01 00:00:00 | 7 | 8 | 11 | 16 | 17 | 18 | 12 | 2
2025-12-01 00:00:00 | 8 | 9 | 12 | 13 | 29 | 30 | 31 | 47
2018-12-01 00:00:00 | 8 | 10 | 15 | 17 | 33 | 34 | 35 | 13
2011-12-01 00:00:00 | 1 | 4 | 5 | 7 | 22 | 29 | 48 | 13
2004-12-01 00:00:00 | 6 | 13 | 19 | 32 | 35 | 40 | 7 | 1
Jan-1 10 | 7 | 9 | 13 | 18 | 27 | 33 | 44 | 15
Spreadsheet: 200272d1355482466-adding-1-darts-2013new
Sheet: mar_a

2005-03-01 00:00:00 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double |  |  |  | Bar 2 B
 |  |  |  |  |  |  |  |  |  | Queimada
 |  | Delfin | V | BYE |  |  |  |  |  | Anchor
 |  | Bar 2 B | V | Aloha A |  |  |  |  |  | Scandals
 |  | Queimada | V | Casino |  |  |  |  |  | Aloha A
 |  | Scandals | V | Village |  |  |  |  |  | Aloha B
 |  | Aloha B | V | Anchor |  |  |  |  |  | Casino
2012-03-01 00:00:00 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double |  |  |  | BYE
 |  |  |  |  |  |  |  |  |  | Village
 |  | Queimada | V | BYE |  |  |  |  |  | Delfin
 |  | Anchor | V | Delfin
 |  | Village | V | Bar 2 B
 |  | Scandals | V | Aloha B
 |  | Aloha A | V | Casino
2019-03-01 00:00:00 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double
 |  | Casino | V | BYE
 |  | Anchor | V | Village
 |  | Aloha B | V | Aloha A
 |  | Bar 2 B | V | Delfin
 |  | Queimada | V | Scandals
2026-03-01 00:00:00 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed Double
 |  | Bar 2 B | V | BYE
 |  | Village | V | Aloha B
 |  | Delfin | V | Casino
 |  | Scandals | V | Anchor
 |  | Aloha A | V | Queimada
Spreadsheet: 874697d1721232856-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Due Simple Solution

Pay Cycle | Amount Due
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: mark_whitt__25313__Epngrts
Sheet: Sheet1

El Paso Natural Gas Rates
 | 2001 | 2002 | 2003 | 2004 | 2005
Fixed
Reservation | 0.29908 | 0.29908 | 0.29908 | 0.29908 | 0.29908
[NAME] | 0.0574 | 0.0574 | 0.0574 | 0 | 0
[NAME]. | 0.00296 | 0.00197 | 0.00164 | 0 | 0
Variable
Usage | 0.0168 | 0.0168 | 0.0168 | 0.0168 | 0.0168
GRI | 0.007 | 0.005 | 0.004 | 0 | 0
ACA | 0.0022 | 0.0022 | 0.0022 | 0.0022 | 0.0022
Total Rate-San Juan
Current Fuel % | 0.0347 | 0.0347 | 0.0347 | 0.0347 | 0.0347
Spreadsheet: 157959d1337938582-conditional-formatting-not-copying-down-in-a-list-excel-2003-0bespoke-follow-up-sheet
Sheet: Sheet1

[NAME] Sheet
Booking Ref: | Course Date: | Complete?
12345 | 2012-06-08 00:00:00 | No
67890 | 2012-06-08 00:00:00 | No
 | 2012-06-08 00:00:00
 | 2012-06-08 00:00:00 | No
 |  | No
 |  | No
 |  | No
 |  | No
 | 2012-06-08 00:00:00 | No
 |  | No
 | 2012-06-08 00:00:00
 | 2012-06-08 00:00:00 | No
 |  | No
 |  | No
 | 2012-06-08 00:00:00
 |  | No
 |  | No
 |  | No
Spreadsheet: 787354d1657734561-autofill-patterns-which-reference-evenly-spaced-columns-rows-example3
Sheet: Prod2

Prod2
 | Company | Assigned Seats | Sub9 | Stat1 | Last Month Change % | Last Year Change % | Percent 1 | Percent 2
 | Customer 3 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 098eef78-4262-457d-ae76-81007baae760
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Q4 2011 - Largest U.S. Venture Capital Investments
Company | City | State | Industry | Stage of Development | Investment Sequence | Amount | Business Description | Investors
Dropbox, Inc. | San Francisco | CA | Software | Expansion | 2 | 250000200 | Provides online file storage and sharing services. | Accel Partners,Benchmark Capital,Goldman, Sachs & Company,Greylock Partners,Index Ventures,Individuals,Institutional Venture Partners,RIT Capital Partners PLC,Sequoia Capital
Better Place, Inc. | Palo Alto | CA | Industrial/Energy | Expansion | 3 | 200012800 | Builds and operates infrastructure and systems for electric vehicles. | [NAME],UBS Capital Corporation,Undisclosed Firm,Undisclosed Firm,Undisclosed Firm,Undisclosed Firm,Undisclosed Firm,VantagePoint Capital Partners
WhaleShark Media, Inc. | [NAME] | TX | Consumer Products and Services | Expansion | 4 | 150000000 | Whale Shark Media, Inc. operates as a marketplace for coupons and deals. | Institutional Venture Partners,J.P. Morgan Asset Management
Fisker Automotive, Inc. | Anaheim | CA | Industrial/Energy | Later Stage | 11 | 108258000 | Fisker Automotive, Inc. designs and manufactures electric vehicles. | Kleiner Perkins Caufield & Byers,New Enterprise Associates, Inc.
Stion Corporation | San Jose | CA | Industrial/Energy | Expansion | 5 | 99999900 | Stion Corporation manufactures thin-film solar panels. | Braemar Energy Ventures,General Catalyst Partners,Khosla Ventures,Lightspeed Venture Partners,Undisclosed Firm,Undisclosed Firm,VentureTech Alliance LLC
Portola Pharmaceuticals, Inc. | South San Francisco | CA | Biotechnology | Later Stage | 8 | 88999800 | Portola Pharmaceuticals, Inc. is a biopharmaceutical company. | Advanced Technology Ventures,Alta Partners,Frazier Healthcare and Technology Ventures,MPM Capital,Prospect Venture Partners,Sutter [NAME],Temasek Holdings Pte, Ltd.,Undisclosed Firm
Soraa, Inc. | Fremont | CA | Semiconductors | Expansion | 3 | 88601000 | Soraa, Inc. operates as a clean-tech semiconductor company. | New Enterprise Associates, Inc.
Workday, Inc. | Pleasanton | CA | Software | Expansion | 3 | 85000000 | Develops SaaS-based enterprise solutions for human resources. | [NAME],Morgan Stanley Alternative Investment Partners,T. Rowe Price Threshold Partnerships,Undisclosed Firm,Undisclosed Firm
Agios Pharmaceuticals, Inc. | Cambridge | MA | Biotechnology | Early Stage | 4 | 78000000 | Develops therapeutics in the field of cancer metabolism. | ARCH Venture Partners,Celgene Corporation,Flagship Ventures,Third Rock Ventures LLC,Undisclosed Firm
Undisclosed | Cambridge | MA | Biotechnology | Early Stage | 1 | 75000000 | Undisclosed | Undisclosed Firm,Undisclosed Firm
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 797136d1663733849-matching-text-to-one-of-multiple-columns-sample-tally-spreadsheet
Sheet: Entries to Compare

First Name | Last Name | Match | Row # of Match | [NAME] | Notes
Abbigail | Wang |  |  |  | [NAME] should return "[NAME]"
Abbe | [NAME] |  |  |  | [NAME] should return ""
[NAME] | [NAME] |  |  |  | [NAME] should return "[NAME]"
Adi | Bells |  |  |  | [NAME] should return "Adison Bell"
[NAME] | Bell |  |  |  | [NAME] should return ""
Ade | Pearson |  |  |  | [NAME] should return ""
[NAME] | Horton |  |  |  | [NAME] should return ""
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 5789 | 7579
2 | 2411 | 7579
3 | 7806 | 7579
4 | 7637 | 7579
5 | 7209 | 7579
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 326755
2001-08-05 00:00:00
CBS Volume
 |  |  | 6289
Spreadsheet: 89f6c599-18de-4bac-a41d-d8b244cab00f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8258 | 40953 | [NAME] | [NAME] | GBR | 725 | [NAME] | 00:03:09 | 00:57:24 | 00:01:31 | 00:47:24 | 1 | 02:03:17
Spreadsheet: 136896d1326878675-data-validation-indirect-lists180112
Sheet: 18012012

TRUCKS
COMPANY |  |  |  |  |  |  |  | INDUCTED |  |  |  | TYPE |  |  | WEIGHT |  |  | START |  |  | [NAME] |  |  |  | DKT NO |  |  |  |  | CONTACT
Company_One |  |  |  |  |  |  |  | YES | #N/A | #N/A | #N/A | Semi |  |  | 32 |  |  | 07.00am |  |  | On Site |  |  |  |  |  |  |  |  | Contact One
Company Two |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | T & D |  |  | 26 |  |  | 07.30am |  |  | AC Plant |  |  |  |  |  |  |  |  | #N/A
Company Three |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | Truck |  |  | 16 |  |  | 07.45am |  |  | AC Plant |  |  |  |  |  |  |  |  | #N/A
Company Four |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | T & D |  |  | 26 |  |  | 08.00am |  |  | AC Plant |  |  |  |  |  |  |  |  | #N/A
Company Five |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | Semi |  |  | 32 |  |  | 08.30am |  |  | AC Plant |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company _One | Truck | Semi
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck | 12 | 32
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Semi | 18
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 859849d1708084780-convert-irregular-data-to-monthly-power_consumption
Sheet: Analysis

Cost/Month~Quarter |  |  |  |  |  | Cost/kWh
2022-07-01 00:00:00 |  | Q3 |  |  |  | 2022-07-01 00:00:00
2022-08-01 00:00:00 |  |  |  |  |  | 2022-08-01 00:00:00
2022-09-01 00:00:00 |  |  |  |  |  | 2022-09-01 00:00:00
2022-10-01 00:00:00 |  | Q4 |  |  |  | 2022-10-01 00:00:00
2022-11-01 00:00:00 |  |  |  |  |  | 2022-11-01 00:00:00
2022-12-01 00:00:00 |  |  |  |  |  | 2022-12-01 00:00:00
2023-01-01 00:00:00 |  | Q1 |  |  |  | 2023-01-01 00:00:00
2023-02-01 00:00:00 |  |  |  |  |  | 2023-02-01 00:00:00
2023-03-01 00:00:00 |  |  |  |  |  | 2023-03-01 00:00:00
2023-04-01 00:00:00 |  | Q2 |  |  |  | 2023-04-01 00:00:00
2023-05-01 00:00:00 |  |  |  |  |  | 2023-05-01 00:00:00
2023-06-01 00:00:00 |  |  |  |  |  | 2023-06-01 00:00:00
2023-07-01 00:00:00 |  | Q3 |  |  |  | 2023-07-01 00:00:00
2023-08-01 00:00:00 |  |  |  |  |  | 2023-08-01 00:00:00
2023-09-01 00:00:00 |  |  |  |  |  | 2023-09-01 00:00:00
2023-10-01 00:00:00 |  | Q4 |  |  |  | 2023-10-01 00:00:00
2023-11-01 00:00:00 |  |  |  |  |  | 2023-11-01 00:00:00
2023-12-01 00:00:00 |  |  |  |  |  | 2023-12-01 00:00:00
2024-01-01 00:00:00 |  | Q1 |  |  |  | 2024-01-01 00:00:00
2024-02-01 00:00:00 |  |  |  |  |  | 2024-02-01 00:00:00
2024-03-01 00:00:00 |  |  |  |  |  | 2024-03-01 00:00:00
2024-04-01 00:00:00 |  | Q2 |  |  |  | 2024-04-01 00:00:00
2024-05-01 00:00:00 |  |  |  |  |  | 2024-05-01 00:00:00
2024-06-01 00:00:00 |  |  |  |  |  | 2024-06-01 00:00:00
2024-07-01 00:00:00 |  | Q3 |  |  |  | 2024-07-01 00:00:00
2024-08-01 00:00:00 |  |  |  |  |  | 2024-08-01 00:00:00
2024-09-01 00:00:00 |  |  |  |  |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 |  | Q4 |  |  |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 |  |  |  |  |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 |  |  |  |  |  | 2024-12-01 00:00:00
Spreadsheet: 117749d1312999581-countif-based-on-certain-criteria-copy-of-dummy-data
Sheet: Sheet1

Date | No. of Logins | Sum of Sanctioned Amount | No. of Holds | No. of Sanctions
2011-08-01 00:00:00
2011-08-02 00:00:00
2011-08-03 00:00:00
2011-08-04 00:00:00
Spreadsheet: 849265d1699803553-credit-card-installment-credit-jt-
Sheet: Data

Account closing date | 4
Payment date | 14
 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
shopping date | product | Account closing date | Payment date | Amount | Number of installments | payment day | status
2023-06-27 00:00:00 | Telephone | 2023-07-04 00:00:00 | 2023-07-14 00:00:00 | 485 | 7
2023-11-03 00:00:00 | Tv | 2003-11-04 00:00:00 | 2023-11-14 00:00:00 | 345 | 3
2023-11-10 00:00:00 | Calculator | 2023-12-04 00:00:00 | 2023-12-14 00:00:00 | 1218.42 | 6
 | 1  The account is closed on the fourth of the month.
 | 2- Payment is made within 10 days
 | 3 Can the installments be distributed over the months starting from the month of the payment date?
 | The distribution will be like this.
2023-06-27 00:00:00 | 2023-07-14 00:00:00 | 69.28
 | 2023-08-14 00:00:00 | 69.28
 | 2023-09-14 00:00:00 | 69.28
 | 2023-10-14 00:00:00 | 69.28
 | 2023-11-14 00:00:00 | 69.28
 | 2023-12-14 00:00:00 | 69.28
 | 2024-01-14 00:00:00 | 69.28
Spreadsheet: 717347d1612605586-creating-a-table-of-unique-records-based-upon-minimum-values-test1
Sheet: Sheet1

 | Input Table |  |  |  |  | Output Table of MINIMUM Time values
 | Course | Distance | Class | Time |  | Course | Distance | Class | Time
 | BEAUDESERT | 1100 | BM58 | 00:01:04.970000 |  | BEAUDESERT | 1100 | BM58 | 00:01:04.970000
 | BEAUDESERT | 1100 | BM58 | 00:01:17.900000 |  | DALBY | 1200 | BM55 | 00:00:57.200000
 | BEAUDESERT | 1100 | BM58 | 00:01:24.610000 |  | DALBY | 1200 | BM55 | 00:01:11.620000
 | BEAUDESERT | 1100 | BM58 | 00:01:25.600000 |  | GATTON | 1100 | RST58 | 00:01:04.330000
 | DALBY | 1200 | BM55 | 00:01:10.950000
 | DALBY | 1200 | BM55 | 00:01:10.460000
 | DALBY | 1200 | BM55 | 00:00:57.200000
 | DALBY | 1200 | BM55 | 00:01:11.620000
 | GATTON | 1100 | RST58 | 00:01:04.330000
 | GATTON | 1100 | RST58 | 00:00:54.460000
 | GATTON | 1100 | RST58 | 00:00:57.820000
 | GATTON | 1100 | RST58 | 00:01:06.780000
Spreadsheet: 674641d1587971926-dynamic-array-cumulative-sum-cumulative-sum-using-dynamic-arrays-problem
Sheet: Model

Dates
 | Period Number |  |  |  |  |  | 2 | 3 | 4 | 5 | 6
 | Date |  |  |  |  |  | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00
No of Existing Memberships Renewals
 |  |  |  |  |  |  | 1100 | 1200 | 1300 | 1400 | 1500
 | Category B |  |  |  |  | 1600 | 1700 | 1800 | 1900 | 2000 | 2100
 | Category C |  |  |  |  | 2200 | 2300 | 2400 | 2500 | 2600 | 2700
 | Category D |  |  |  |  | 2800 | 2900 | 3000 | 3100 | 3200 | 3300
Total No of Existing Memberships Renewals |  |  |  |  |  |  | 8000 | 8400 | 8800 | 9200 | 9600
No of Existing Memberships |  |  |  | No of members as at Model Start date
 | Category B |  |  | 2000 |  | 3000
 | Category C |  |  | 3000 |  | 6000
 | Category D |  |  | 4000 |  | 10000
 |  |  |  |  |  | Desired Results
 | Category B |  |  | 2000
 | Category C |  |  | 3000
 | Category D |  |  | 4000
Spreadsheet: 00a3e07a-e872-443e-b6c4-083d578b7e25
Sheet: Sheet1

[NAME] | n=15 | n=9 | n=3 | n=6
Course Questions | Fall 2012 | Sp. 2013 | Fall 2013 | Sp. 2014
Reflective Piece | 12 | 13 | 12 | 12
Assessment | 11 | 12 | 10 | 10
Engagement and Motivation | 10 | 13 | 9 | 9
Management | 9 | 11 | 9 | 12
Planning and Instruction | 14 | 12 | 12 | 11
Professionalism | 12 | 13 | 15 | 12