tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26156d1218071657-creating-a-time-sheet-for-attorney-billing-client-time-and-billing-statement-1-
Sheet: Weekly time record

 |  |  |  |  |  |  |  | Weekly Client Time and Billing Statement
 | Client Name
 | Attorney
 | The Week of: |  | 2008-08-06 00:00:00
 | Day | Date |  | Start Time | End Time | Task Description |  | Total Manhours expended
 | Monday |  |  | 08:25:00 | 08:45:00 |  |  | 0.3333333333333335
 | Tuesday |  |  | 11:15:00 | 13:30:00 |  |  | 2.25
 | Wednesday |  |  |  |  |  |  | 1900-01-01 00:00:00
 | Thursday |  |  |  |  |  |  | 1900-01-01 00:00:00
 | Friday |  |  |  |  |  |  | 1900-01-01 00:00:00
 | Saturday |  |  |  |  |  |  | 1900-01-01 00:00:00
 | Sunday |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  | Total hours |  |  |  |  |  | 2.583333333333333
 |  | Rate per hour |  |  |  |  |  | 125
 |  | Total pay |  |  |  |  |  | 322.9166666666667
Spreadsheet: 107159d1304376264-help-with-excel-2010-grading-sheet
Sheet: Homework

High Plains School
[NAME]
 | Assignments
 | Chapter 10 Review (page 555-556) | Exercise 11-1: 2, 4, 6, 8, 10, 12 (bcd) Exercise 11-2: 2 - 46 ([NAME]) | Exercise 11-3: 2, 4, 6, 8, 10, 14, 16, 18, 20, 22, 26, 28 | Exercise 11-4: 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 24, 26, 28, 30, 32, 34 | Exercise 11-5: 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 26, 28, 30, 32 | Exercise 11-6: 2, 4, 6, 8, 10, 12, 14, 16, 21, 22 | Exercise 11-7: 2, 4, 6, 8, 16, 20 (abc) | Exercise 11-8: 2, 4, 8, 16, 18, 24, 26,30, 32 | Chapter 11 Review: R1 -- R10 | Exercise 11-10: 2, 4, 6, 10, 14, 16, 20, 22, 46, 26, 30, 34, 38, 42, 44, 48, 54 | Exercise 12-2: 2 Exercise 12-3: 2, 4, 6, 12, 14, 16, | Exercise 12-5: 2, 6, 10, 12, 14, 16, 18, 20, 22, 30, 32, 36 Exercise 12-6: 2, 4, 6, 8, 10, 12 | Chapter 12 Review: R1 -- R5 | Cumulative Review
 | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points
 | 40 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 40 | 20 | 20 | 20 | 40 | 80
Student | Score | Score | Score | Score | Score | Score | Score | Score | Score | Score | Score | Score | Score | Score
 | 35 | 20 | 18 | 19 | 20 | 20 | 18 | 18 | 36 | 18 | 20 | 20 | 38 | 77
 | 38 | 15 | 20 | 17 | 18 | 16 | 15 | 35 | 35 | 16 | 20 | 15 | 39 | 66
 | 34 | 20 | 19 | 20 | 16 | 18 | 15 | 18 | 40 | 15 | 17 | 20 | 39 | 69
 | 36 | 18 | 18 | 16 | 20 | 17 | 18 | 18 | 36 | 18 | 11 | 15 | 36 | 68
 | 37 | 20 | 20 | 19 | 20 | 15 | 20 | 20 | 35 | 20 | 20 | 12 | 37 | 70
 | 40 | 20 | 20 | 20 | 20 | 19 | 20 | 20 | 40 | 20 | 20 | 20 | 40 | 78
 | 31 | 15 | 17 | 20 | 19 | 20 | 17 | 20 | 37 | 21 | 15 | 20 | 37 | 55
 | 26 | 17 | 15 | 14 | 16 | 12 | 16 | 14 | 37 | 12 | 13 | 20 | 32 | 56
 | 33 | 18 | 14 | 18 | 13 | 20 | 14 | 14 | 33 | 18 | 15 | 17 | 31 | 56
 | 36 | 20 | 20 | 20 | 20 | 20 | 24 | 20 | 36 | 20 | 15 | 20 | 39 | 72
 | 35 | 20 | 18 | 19 | 20 | 20 | 16 | 16 | 35 | 19 | 20 | 19 | 34 | 67
 | 30 | 16 | 17 | 20 | 18 | 12 | 12 | 16 | 26 | 16 | 12 | 18 | 35 | 56
 | 31 | 17 | 20 | 18 | 12 | 13 | 17 | 12 | 28 | 14 | 15 | 16 | 27 | 76
 | 40 | 20 | 20 | 17 | 20 | 18 | 17 | 19 | 39 | 20 | 17 | 17 | 38 | 71
 | 40 | 16 | 20 | 20 | 20 | 20 | 20 | 19 | 40 | 20 | 20 | 20 | 40 | 80
 | 35 | 17 | 15 | 19 | 20 | 20 | 20 | 20 | 33 | 20 | 20 | 18 | 38 | 73
 | 37 | 20 | 19 | 18 | 18 | 18 | 16 | 16 | 35 | 20 | 17 | 18 | 40 | 71
 | 28 | 20 | 16 | 20 | 13 | 12 | 14 | 19 | 26 | 12 | 18 | 12 | 31 | 51
 | 32 | 20 | 19 | 16 | 15 | 20 | 20 | 19 | 33 | 20 | 17 | 15 | 30 | 60
 | 30 | 15 | 20 | 16 | 20 | 15 | 20 | 20 | 38 | 16 | 20 | 19 | 30 | 60
Spreadsheet: robin_rodrigue__33274__P&LSum
Sheet: SUM-USD

SUMMARY OF CANADA'S TRADING INCOME BY TRADER - IN US$
FX - AVG OF MNTH
 |  |  |  |  |  |  |  |  |  |  |  | MTD |  |  |  |  |  |  | To date
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | TOTAL |  | Q1 | Q2 | Q3 | Q4 |  | TOTAL
BY BOOK:
TERM: | (Note:  Q1 Orgination has been manually backed out)
[NAME]
BC Term
EOL - Term
Options
CASH
[NAME]
BC Cash
BC Pipe Cash
[NAME]
BC Term - GD
Options - GD
Power
PMA
TOTAL CANADA
BY RISK TYPE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BY RISK TYPE:
Total Term
Check
Total Cash
Check
TOTAL CANADA
BY AREA/TRADER:
West Term - Lavorato
West Term - Mckay
West Term - Lambie
Options - Disturnal
[NAME]
BC Cash - Clark
Power - Greenizan
TOTAL CANADA
Check
Spreadsheet: 94344d1294181162-need-help-creating-formula-for-conditional-counting-test
Sheet: Sheet1

Name | Type | Q1
[NAME] | 1 | 1
[NAME] | 1 | 5
Billy | 2 | 2
[NAME] | 4 | 1
[NAME] | 2 | 2
Nicole | 3 | 3
[NAME] | 5 | 1
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 3

 | November 22 | November 29 | December 6 | December 13 | December 20
Total Interest Rate* | 16121 | 11858 | 19841 | 21362 | 23541
Cleared** | 11354 | 10325 | 14933 | 15309 | 20423
Uncleared | 4767 | 1533 | 4908 | 6053 | 3118
Total Cross-Currency | 817 | 223 | 639 | 961 | 643
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 817 | 223 | 639 | 961 | 643
Total Credit | 13918 | 4729 | 8103 | 4835 | 6122
Cleared | 6302 | 2918 | 5232 | 3266 | 4632
Uncleared | 7616 | 1811 | 2871 | 1569 | 1490
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 30856 | 16810 | 28583 | 27158 | 30305
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 124378d1318357286-calculate-hi-points-points-2-
Sheet: Scoring

All Breed Yearling In Hand Trail |  |  |  |  | [NAME] |  |  |  |  | All Breed Walk Trot Trail |  |  |  |  | All Breed Youth Trail 13-U
 |  | Back # |  |  |  |  | Back # |  |  |  |  | Back # |  |  |  |  | Back #
Judge A Saturday | 1st |  |  |  | Judge A Saturday | 1st |  |  |  | Judge A Saturday | 1st |  |  |  | Judge A Saturday | 1st
 | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd
 | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd
 | 4th |  |  |  |  | 4th |  |  |  |  | 4th |  |  |  |  | 4th
 | 5th |  |  |  |  | 5th |  |  |  |  | 5th |  |  |  |  | 5th
 | 6th |  |  |  |  | 6th |  |  |  |  | 6th |  |  |  |  | 6th
Judge B Saturday | 1 | 154 |  |  | Judge B Saturday | 1st |  |  |  | Judge B Saturday | 1st |  |  |  | Judge B Saturday | 1st
 | 2 | 111 |  |  |  | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd
 | 3 | 112 |  |  |  | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd
 | 4 | 3 |  |  |  | 4th |  |  |  |  | 4th |  |  |  |  | 4th
 | 5 | 88 |  |  |  | 5th |  |  |  |  | 5th |  |  |  |  | 5th
 | 6 | 99 |  |  |  | 6th |  |  |  |  | 6th |  |  |  |  | 6th
Judge A Sunday | 1st |  |  |  | Judge A Sunday | 1st |  |  |  | Judge A Sunday | 1st |  |  |  | Judge A Sunday | 1st
 | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd
 | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd
 | 4th |  |  |  |  | 4th |  |  |  |  | 4th |  |  |  |  | 4th
 | 5th |  |  |  |  | 5th |  |  |  |  | 5th |  |  |  |  | 5th
 | 6th |  |  |  |  | 6th |  |  |  |  | 6th |  |  |  |  | 6th
Judge B Sunday | 1st |  |  |  | Judge B Sunday | 1st |  |  |  | Judge B Sunday | 1st |  |  |  | Judge B Sunday | 1st
 | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd |  |  |  |  | 2nd
 | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd |  |  |  |  | 3rd
 | 4th |  |  |  |  | 4th |  |  |  |  | 4th |  |  |  |  | 4th
 | 5th |  |  |  |  | 5th |  |  |  |  | 5th |  |  |  |  | 5th
 | 6th |  |  |  |  | 6th |  |  |  |  | 6th |  |  |  |  | 6th
I would like to start out with this at the beginning of the day. As the horses are shown and placed I would like to insert the back number into the back numbers column and have the points calculated and entered onto the Summary page. Points are calculated as follows-if there are six or more horses in the class then first place gets six points, 2nd place gets five, 3rd place gets four, 4th place gets three, 5th gets two and 6th gets one. And if,  for example, there on only four in the class then 1st get four, 2nd three, 3rd two and 4th.  If a number could be pulled out of the Back Number Database so that Horse/Owner and Exhibitor is displayed on the summary page it would be great also. There are a hundred classes I would like to calculate like this.
Spreadsheet: 0293480b-4bb2-4bf4-b3be-d368e5136ce3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
[NAME] dell'Istruzione,[NAME] e della Ricerca
UFFICIO SCOLASTICO REGIONALE PER LA LOMBARDIA
UFFICIO XI - LODI
UTILIZZAZIONI ED ASSEGNAZIONI PROVVISORIE PERSONALE DOCENTE SCUOLA PRIMARIA A.S. 2011/12
UTILIZZI
POSTO | COGNOME NOME | [NAME]' | SEDE UTILIZZO
SOSTEGNO | [NAME] | MALEO | CODOGNO
COMUNE | NUCERA SILVANA | D.D. "MORZENTI" S.ANGELO L. | D.D. I CIRCOLO
POSTO | COGNOME NOME | [NAME]' | SEDE DI UTILIZZO
COMUNE | ANELLI LUISA | III CIRCOLO | C.T.P. DI LODI
COMUNE | SORESINI PATRIZIA | I.C. TAVAZZANO | C.T.P. DI LODI
COMUNE | LAZZARIN ANNA | D.D. III CIRCOLO LODI | C.T.P. DI LODI
COMUNE | [NAME] | III CIRCOLO | IV CIRCOLO LODI
COMUNE | GALETTA EMENUELA | I.C. LODIVECCHIO | II CIRCOLO LODI
COMUNE | ZAMBELLI CLAUDIA | I.C. BORGHETTO LOD. | I.C. CAZZULANI
COMUNE | VAILETTA MANUELA | I.C. CAZZULANI | I.C. BORGHETTO
COMUNE | MORETTI ELENA | II CIRCOLO | D.D. III CIRCOLO
COMUNE | ZAMBONI FABRIZIO | D.D."COLLODI" | D.D. "R.MORZENTI"
ASSEGNAZIONE PROVVISORIE IN PROVINCIA
POSTO | COGNOME NOME | [NAME]' | SEDE DI ASSEGNAZIONE
SOSTEGNO | FUSCALDO ROBERTO | D.D. "COLLODI" | D.D. I CIRCOLO
SOSTEGNO | LANGELLOTTI ANNAMARIA | I.C. MALEO | D.D. CODOGNO
COMUNE | MAZZUCCO TIZIANA | D.D. "COLLODI" | I.C. BORGHETTO
COMUNE | ELMISI ILARI MARIA GIOVANNA | I.C. CASTIGLIONE D'ADDA | D.D. I CIRCOLO
COMUNE | CATTANEO MARIA | D.D. CASALPUSTERLENGO | I.C. CASTIGLIONE D'ADDA
COMUNE | FACENTE MARIETTA | D.D. IV CIRCOLO | D.D.III CIRCOLO
COMUNE | DI BIASIO ANTONELLA | I.C. ZELO BUON PERSICO | D.D. II CIRCOLO
UTILIZZI ED ASSEGNAZIONI PROVVISORIE PERSONALE DOCENTE SC. DELL'INFANZIA [NAME]
ASSEGNAZIONE PROVVISORIE
POSTO | COGNOME NOME | [NAME]' | SEDE DI ASSEGNAZIONE
SOSTEGNO | LENTINI ROSA MARIA | D.D. I CIRCOLO LODI | D.D. "GENTILE" CODOGNO
COMUNE | SCAGLIA ANNA MARIA | I.C.TAVAZZANO | D.D. III CIRCOLO LODI
 |  | IL DIRIGENTE
 |  | [NAME]
GS/ct
Spreadsheet: 137157d1326982351-attaching-an-associated-location-to-a-name-sample-book
Sheet: Sheet2

Beadle, [NAME] |  | 2467
Alsop, [NAME] |  | 354
Handy, [NAME] |  | 50
Boath, [NAME] |  | -354
[NAME], [NAME] |  | 354
Beebee, [NAME] |  | -50
Godden, [NAME] |  | 50
Sparrow, [NAME] |  | 404
Thompson, Jon |  | 12
[NAME], [NAME] |  | 71
[NAME], [NAME] |  | -12
Smith, [NAME] |  | 12
Lord, [NAME] |  | -71
[NAME], [NAME] |  | 71
[NAME], [NAME] |  | 83
[NAME], [NAME] |  | 24
[NAME], [NAME] |  | 48
Abbott, Victoria |  | 378
Herrington, [NAME] |  | -24
Skelton, [NAME] |  | 24
Gray, Lesley |  | -48
[NAME], [NAME] |  | 48
[NAME], Oliver |  | 450
Downs, [NAME] |  | 15
Wilson, [NAME] |  | 15
[NAME], [NAME] |  | 50
Brain, [NAME] |  | 50
[NAME], [NAME] |  | 75
Wilkinson, Stephen |  | 175
Myers, [NAME] |  | 469
Wiseman, [NAME] |  | 238
Kerr, [NAME] |  | -429
Wilson, [NAME] |  | 429
Heywood, Trevor |  | -469
Higton, [NAME] |  | 469
[NAME], Victoria |  | 707
Kitching, [NAME] |  | 145
Delaney, Louis |  | 145
Baines, [NAME] |  | 290
[NAME], [NAME] |  | 42
Slee, [NAME] |  | 260
Bradburn, [NAME] |  | 302
[NAME], [NAME] |  | 216
[NAME], [NAME] |  | -216
[NAME], [NAME] |  | 216
[NAME], [NAME] |  | 216
Cummings, Rachel |  | 329
[NAME], [NAME] |  | 329
[NAME], [NAME] |  | 414
Goundry, [NAME] |  | 390
Shepherd, [NAME] |  | 402
Berry, [NAME] |  | -424
Smith, [NAME] |  | 424
Clemson, [NAME] |  | 443
Dunn, [NAME] |  | 388
[NAME], [NAME] |  | 392
Winter, [NAME] |  | 2429
[NAME], [NAME] |  | 390
[NAME], Graeme |  | 60
Forty, Cleveland |  | 260
White, Clive |  | 710
[NAME], [NAME] |  | 20
[NAME], [NAME] |  | -20
[NAME], [NAME] |  | 20
Swales, [NAME] |  | 20
Hughes, [NAME] |  | 156
Smith, Nikki |  | 468
[NAME], [NAME] |  | 624
Jones, [NAME] |  | 400
[NAME], Stephen |  | 400
Jones, [NAME] |  | -400
Odaro, Otas |  | 400
Sherratt, Mark |  | 800
Richards, [NAME] |  | 208
Maddison, [NAME] |  | 208
Macleod, [NAME] |  | 30
Carroll, [NAME] |  | 30
King, Iain |  | 260
Perrin, Sue |  | -260
Armstrong, [NAME] |  | 260
Wilkins, [NAME] |  | 260
[NAME], [NAME] |  | 160
Higginson, [NAME] |  | 160
Bowes, [NAME] |  | 400
Spreadsheet: 44208d1242842804-excel-2007-compatability-issue-testing
Sheet: SEPT_OCT

No. | Date | PURCHASES | AMOUNT |  | ELECTRONICS | GROCERY | BOOKS AND [NAME] | MISCELLEANOUS | PETROL
3 | 2009-09-16 00:00:00 | FOOD LION #1454 RALEIGH NC | 11.24
4 | 2009-09-17 00:00:00 | BIG LOTS #[PHONE] RALEIGH NC | 13.97
5 | 2009-09-22 00:00:00 | MARLIN P JONES & ASSOC [PHONE] FL | 50.05
6 | 2009-09-24 00:00:00 | [NAME] RALEIGH NC
7 | 2009-09-24 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.19
8 | 2009-09-25 00:00:00 | FOOD LION #1454 RALEIGH NC | 23.17
9 | 2009-09-27 00:00:00 | ALMANDINA SUPER MARKET RALEIGH NC | 6.6
10 | 2009-09-29 00:00:00 | FOOD LION #1454 RALEIGH NC | 12.68
11 | 2009-09-30 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 1.18
12 | 2009-10-01 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34
13 | 2009-10-04 00:00:00 | ALMANDINA SUPER MARKET RALEIGH NC | 22.56
14 | 2009-10-06 00:00:00 | BURGER KING #4521 Q07 RALEIGH NC | 10.8
15 | 2009-10-06 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 1.42
16 | 2009-10-06 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 0.6
17 | 2009-10-07 00:00:00 | PAYPAL *[NAME] | 15.75
18 | 2009-10-07 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34
19 | 2009-10-08 00:00:00 | PAYPAL *IWANNEBUY [PHONE] CA | 11.31
20 | 2009-10-08 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.34
21 | 2009-10-09 00:00:00 | SIX TWELVE CONVENI RALEIGH NC | 1.05
22 | 2009-10-09 00:00:00 | PAYPAL *NJLASZ [PHONE] CA | 10.99
23 | 2009-10-09 00:00:00 | [NAME] | 20
24 | 2009-10-11 00:00:00 | ALLIED ELECTRONICS INC [PHONE] TX | 39.53
25 | 2009-10-11 00:00:00 | PAYPAL *WIDGETSUPPL [PHONE] OR | 6.38
26 | 2009-10-11 00:00:00 | PAYPAL *[NAME] CA | 6.45
27 | 2009-10-12 00:00:00 | BIG LOTS #[PHONE] RALEIGH NC | 7.44
28 | 2009-10-14 00:00:00 | FOOD LION #1454 RALEIGH NC | 6.07
Spreadsheet: 889820d1740748795-creating-table-of-varying-columns-per-row-excel_reddit
Sheet: Sheet1

Size | ID | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8
2 |  |  | A-02 |  |  |  |  |  |  |  |  | A-02
4 |  |  | A-02 | A-03 | A-04 |  |  |  |  |  | A-03 | A-04 | A-05 | A-06
3 |  |  | A-02 | A-03 |  |  |  |  |  |  | A-07 | A-08 | A-09
8 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 | A-01 | A-02 |  | A-10 | A-11 | A-12 | A-13 | A-14 | A-15 | A-16 | A-17
6 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 |  |  |  | A-18 | A-19 | A-20 | A-21 | A-22 | A-23
7 |  |  | A-02 | A-03 | A-04 | A-05 | A-06 | A-01 |  |  | A-24 | B-25 | B-26 | B-27 | B-28 | B-29 | B-30
2
4
3
8
6
7
 |  | TRIED:
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1),TEXT(MOD(SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+COLUMN()-COLUMN($C12), 12)+1, "00"),"")
 |  | IF(COLUMN()-COLUMN($C22)+1<=INDEX($A$22:$A$27, ROW()-ROW($C$22)+1), TEXT(MOD(COLUMN()-COLUMN($C22), 8)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+COLUMN()-COLUMN($C12)-SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)))+1, 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(IF(ROW()=ROW($C$12), 0, SUM($A$12:INDEX($A$12:$A$17, ROW()-ROW($C$12)-1)))+COLUMN()-COLUMN($C12), 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C12)+1<=INDEX($A$12:$A$17, ROW()-ROW($C$12)+1), TEXT(MOD(IF(ROW()=ROW($C$12), 0, SUM($A$12:INDEX($A$12:$A$17, MAX(ROW()-ROW($C$12)-1, 0))))+COLUMN()-COLUMN($C12), 12)+1, "00"), "")
 |  | IF(COLUMN()-COLUMN($C2)+1<=INDEX($A$2:$A$9, ROW()-ROW($C$2)+1), [NAME]), 0, SUM($A$2:INDEX($A$2:$A$9, ROW()-ROW($C$2)-1)))+COLUMN()-COLUMN($C2), 12)+1, "00"), "")
Spreadsheet: 715840d1611876475-multiple-if-formula-sample-workbook
Sheet: Pivot

Row Labels | [NAME] | Guy | Rod | [NAME] | Shiv | Mark
A | 1792067
B | 1738158.411764706 |  |  | 1823343 | 1721547.1 | 1672354
C | 2576099 |  | 2475846 |  | 223534 | 2298751
D | 3802482.555555556 |  |  |  | 4225497 | 3256475
E |  |  | 975787 |  |  | 874854
F | 583155.4666666667 |  | 396000 | 570959 | 577480.3571428572 | 434966
G | 878762.8888888889 |  | 720422.2222222222 |  | 743923.9166666666 | 647848
H | 134038.17142857 | 1406593 | 919429.6666666666 |  | 1097670.75 | 910117
Spreadsheet: 839720d1692183910-sumproduct-sum-from-multiple-sheets-depending-on-specific-month-file
Sheet: 4

4 |  | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY
 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals
 |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312
Opening |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 194093d1353033565-lock-fields-until-one-field-has-been-filled-in-sample
Sheet: 1 x CrossBeam

BEAM | WELD | WPS # | HEAT # | WELDER | DATE | NDT | VISUAL | MPI | MPI | UT | UT | C/DNC | CHECKED | PWHT # | PWHT Report # | HEAT # | CERTIFICATE | W/ WIRE
# | # |  | SHS | ID | WELDED | REQUEST # | REPORT # | Y/N | REPORT # | Y/N | REPORT # |  |  |  |  | END PLATES | # | BATCH #
1 | 1 | 93-1
 | 2 | 93-1
Spreadsheet: 168484d1342470533-sumif-formula-for-months-sumif-sample
Sheet: Sheet1

 | Estimated Date of PI Receipt | Total Estimated PI
 | 2012-06-30 00:00:00 | 50
 | 2012-06-30 00:00:00 | 100
 | 2012-07-30 00:00:00 | 2
 | 2012-08-23 00:00:00 | 2
 | 2012-06-30 00:00:00 | 50
 |  | Estimated PI
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
Spreadsheet: 192104d1352308263-looking-for-a-text-string-and-putting-that-cell-value-into-a-table-excel-forum-example
Sheet: Sheet1

 | COLUMN B | COLUMN C | COLUMN D | COLUMN E |  | Search Text | Results
ROW 2 | Address: 105 Fairway Green Drive Wilmington, NC ; 28557 |  |  |  |  | Aprx Htd SqFt:
ROW 3 | MLS#: 121-458 |  | List Price: $ 229,900 |  |  | SqFt. Upper:
ROW 4 | Property Type: Residential |  | Sales Price: $201,000 |  |  | SqFt. Lower:
ROW 5 | Pin 15: | 635606286652000 |  |  |  | Year Built:
ROW 6 | Status: Closed |  | Bank OwnedNo |  |  | [NAME]:
ROW 7 | Type:Single Family Residential |  | Zoning: | Residential |  | [NAME]:
ROW 8 | Lot Size: | 135 x 125 | Style: [NAME] |  |  | Prop. Taxes:
ROW 9 | Subdivision: [NAME] |  | Subdivision Phase:IV |  |  | Tax Year:
ROW 10 | Area: Morehead City |  | Lot #: | 16 |  | Lot #:
ROW 11 | Rooms: | 8 | Aprx Lot Acres: | 0.39 |  | Aprx Lot Acres:
ROW 12 | Bedrooms: 3 |  |  |  |  | Zoning:
ROW 13 | Bathrooms: 2.00 |  |  |  |  | Lot Size:
ROW 14 | Half Baths: 1.0 |  |  |  |  | Pin 15:
ROW 15 | Aprx Htd SqFt: | 2300 | [NAME]: | X |  | Address:
ROW 16 | SqFt. Upper: | 550 | [NAME]: | 350 |  | MLS#:
ROW 17 | SqFt. Lower: | 1750 | Prop. Taxes: | 1275 |  | List Price:
ROW 18 | Year Built: | 2005 | Tax Year: | 2012 |  | Sales Price:
 |  |  |  |  |  | Status:
 |  |  |  |  |  | Type
 |  |  |  |  |  | Bank Owned
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User6

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-11-24 00:00:00
 | Pliers | Knipex Combination Pliers, 200mm Overall | 80.76 | Y
Total
Spreadsheet: 85753d1285786889-sorting-womens-grand-prix-2010
Sheet: 4.5 Mixed

Rank | Name | Total | Average | Barber City | ISS/LG Open | SOCC Spring Classic | Tournament 4 | Tournament 5 | Tournament 6 | Tournament 7 | Tournament 8 | Tournament 9 | Tournament 10
1 | [NAME] | 220 | 40 | 0 | 140 | 80
2 | [NAME] | 120 | 33.33333333333334 | 80 | 0 | 40
3 | [NAME] | 100 | 33.33333333333334 | 10 | 80 | 10
4 | [NAME] | 60 | 20 | 20 | 20 | 20
5 | [NAME] | 60 | 20 | 40 | 0 | 20
6 | [NAME] | 55 | 18.33333333333333 | 0 | 40 | 15
7 | [NAME] | 40 | 13.33333333333333 | 0 | 40 | 0
8 | [NAME] | 25 | 8.333333333333334 | 0 | 25 | 0
9 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
10 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
11 | [NAME] | 20 | 6.666666666666667 | 20 | 0 | 0
12 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
13 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
14 | [NAME] | 15 | 5 | 15 | 0 | 0
15 | Heather Farrer | 10 | 3.333333333333333 | 0 | 10 | 0
16 | [NAME] | 10 | 3.333333333333333 | 0 | 10 | 0
17 | [NAME] | 10 | 3.333333333333333 | 0 | 10 | 0
18 | Hedy Bloom | 10 | 3.333333333333333 | 0 | 10 | 0
19 |  | 0 | 0 | 0
20 |  | 0 | 0 | 0
21 |  | 0 | 0 | 0
22 |  | 0 | 0 | 0
23 |  | 0 | 0 | 0
24 |  | 0 | 0 | 0
25 |  | 0 | 0 | 0
26 |  | 0 | 0 | 0
27 |  | 0 | 0 | 0
28 |  | 0 | 0 | 0
29 |  | 0 | 0 | 0
30 |  | 0 | 0 | 0
31 |  | 0 | 0 | 0
32 |  | 0 | 0 | 0
33 |  | 0 | 0 | 0
34 |  | 0 | 0 | 0
35 |  | 0 | 0 | 0
36 |  | 0 | 0 | 0
37 |  | 0 | 0 | 0
38 |  | 0 | 0 | 0
39 |  | 0 | 0 | 0
40 |  | 0 | 0 | 0
41 |  | 0 | 0 | 0
42 |  | 0 | 0 | 0
43 |  | 0 | 0 | 0
44 |  | 0 | 0 | 0
45 |  | 0 | 0 | 0
46 |  | 0 | 0 | 0
47 |  | 0 | 0 | 0
48 |  | 0 | 0 | 0
49 |  | 0 | 0 | 0
50 |  | 0 | 0 | 0
51 |  | 0 | 0 | 0
52 |  | 0 | 0 | 0
53 |  | 0 | 0 | 0
54 |  | 0 | 0 | 0
55 |  | 0 | 0 | 0
56 |  | 0 | 0 | 0
57 |  | 0 | 0 | 0
58 |  | 0 | 0 | 0
59 |  | 0 | 0 | 0
60 |  | 0 | 0 | 0
61 |  | 0 | 0 | 0
62 |  | 0 | 0 | 0
63 |  | 0 | 0 | 0
64 |  | 0 | 0 | 0
65 |  | 0 | 0 | 0
66 |  | 0 | 0 | 0
67 |  | 0 | 0 | 0
68 |  | 0 | 0 | 0
69 |  | 0 | 0 | 0
70 |  | 0 | 0 | 0
71 |  | 0 | 0 | 0
72 |  | 0 | 0 | 0
73 |  | 0 | 0 | 0
74 |  | 0 | 0 | 0
Spreadsheet: 763619d1642270279-find-some-with-consecutive-days-log-book-new-for-excel-forum-1-
Sheet: LogBook

 |  |  |  |  |  |  |  |  |  |  |  | 3 | Consecutive days
183 | 2012-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
184 | 2012-09-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | Expected answer would be 12.6
185 | 2012-09-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
186 | 2012-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
187 | 2012-09-20 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
188 | 2012-09-23 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
189 | 2012-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
190 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  |  | 4.8
191 | 2012-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
192 | 2012-09-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1
193 | 2012-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
194 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7 | 8.7
195 | 2012-10-02 00:00:00 |  |  |  |  |  |  |  |  |  | 5.8
196 | 2012-10-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
197 | 2012-10-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
198 | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2.4
199 | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
200 | 2012-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 0.2
201 | 2012-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
202 | 2012-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 3

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 156 | 45 | 111 | 105 | 71 | 97.6 | 488
CONFLICTS | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ID'S | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ISA | 0 | 0 | 0 | 0 | 0 | #N/A | 0