tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878074d1725025609-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-drewber-providernames-updated-365-aligw
Sheet: Sheet1

REF? | ID | PATIENT | DATE | PROVIDER
 | a1234 | Smith, W | 2024-06-25 00:00:00 | BARNEY, A
y | b1234 | Smith, X |  | FRED, B
 | c1234 | Smith, Y | 2024-05-13 00:00:00 | WILMA, C
 | d1234 | Smith, Z | 2024-04-19 00:00:00 | BETTY, D
 | E1234 | Jones, A |  | PEBBLES, E
X | f1234 | Jones, B | 2023-08-01 00:00:00 | BAMBAM, F
 | f1235 | Jones, C |  | DINO, G
Z | f1236 | Jones, D |  | ALBA, J
Spreadsheet: 738849d1625287974-calculating-running-average-cost-example_avg_cost-warehouse-approach-v3-
Sheet: Version8

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Amount | Quantity | Price | Amount | Quantity | Price | Amount | Gain(+) /     Loss(-) | Gain(+) /     Loss(-) per Sales Only |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase |  |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase |  |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase |  |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase |  |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase |  |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 | Sale | 2021-06-30 00:00:00 | Partial | Short | -100 | 50 | 0
 | Sale | 2021-07-01 00:00:00 | Partial | Short | -100 | 50 | 0
 | Purchase | 2021-07-02 00:00:00 |  |  | 60 | 100 | 0
 | Purchase | 2021-07-03 00:00:00 |  |  | 60 | 100 | 0
 | Sale | 2021-07-04 00:00:00 | Partial | Short | -75 | 10 | 0
 | Sale | 2021-07-05 00:00:00 | Partial | Short | -50 | 10 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
Totals: |  |  |  | Purchase
 |  |  |  | Sale
Spreadsheet: 723751d1615882497-excel-help-with-index-and-match-view-test-ans
Sheet: Sheet2

Cust No | Date Of Report | Driver reporting Issue | Leader on duty | Description of Defect | Comments
36 | 2021-01-20 00:00:00 | Driver | Shaun | electric | not charging
39 | 2021-01-28 00:00:00 | Driver | [NAME] | electric | doesn’t hold charge, please ring for repair.
43 | 2021-02-02 00:00:00 | Driver | Shaun | Insufficent Lighting | Light outside  not working,
43 | 2021-02-03 00:00:00 | Driver | Shaun | Other - Please Specify in comments | door mag not securing
39 | 2021-02-12 00:00:00 | Driver | Shaun | Empties | . Making it very difficult to deliver
27 | 2021-02-13 00:00:00 | Driver | Shaun | electric | not charging
54 | 2021-02-13 00:00:00 | Driver | Shaun | electric | very slow and causing the delivery to take longer
39 | 2021-02-17 00:00:00 | Driver | [NAME] | electric | runs out battery after 10
57 | 2021-02-19 00:00:00 | Driver | Shaun | Empties | bay blocked
38 | 2021-02-19 00:00:00 | Driver | Shaun | Empties | blocked
Spreadsheet: 598505d1542553032-calculate-sum-from-partial-list-book1-36-ans
Sheet: Sheet1

Person | Salary | Person 3 | Person 4 | Person 5 | Person 6 | Person 7
Person 1 | 10
Person 2 | 20
Person 3 | 30
Person 4 | 40
Person 5 | 50
Person 6 | 60
Person 7 | 70
Person 8 | 80
Person 9 | 90
Person 10 | 100
Person 11 | 110
Person 12 | 120
Person 13 | 130
Person 14 | 140
Person 15 | 150
Person 16 | 160
Person 17 | 170
Person 18 | 180
Person 19 | 190
Person 20 | 200
Spreadsheet: 6ad1031e-6876-4481-8dfd-ec7868b1d79c
Sheet: Sheet1

San Diego Community College                                                                                                                                                                       Work Experience Education Record of Work / Intern Hours | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 | Student Name |  |  |  |  |  |  |  |  |  |  | Semester |  | Spring |  |  | Year | 2014
 |  |  |  |  | Last |  | First |  |  | M.I.
 | CRN |  | Work Experience Units |  |  |  |  |  | Work Experience Instructor
 | Paid Work |  |  |  | Non-paid Work |  |  |  |  | Required Minimum Work  / Intern  Hours
 | Company Information
 |  |  |  |  |  |  | Name |  |  |  |  |  |  |  | Supervisor/Mentor's Name
DIRECTIONS:   1) Fill in the beginning date for each week of the semester.   2) For each work shift, indicate the time in hours and then the minutes in quarter hour increments. Round minutes to the nearest quarter hour (Example: 4.25 hrs). Do not report the shift beginning and ending time, but the total time worked. (Example: 4.5 hrs).  [NAME] recording your work hours prior to the second site visit.  It is all right to ESTIMATE your work hours for the last two weeks of the semester.  3) Your work supervisor will sign at the bottom of the form to verify your hours.  Return this form to your instructor at the second site visit or the on-campus evaluation.                                                                                                                                    Important Notes: Students may include hours worked/interned on holidays if these fall within the session beginning and ending dates. All hours worked/interned, even hours not devoted specifically to objective accomplishment can be counted. Vacation days paid by employers may not be counted.
Week |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 10 | 11 | 12 | 13 | 14 | 15 | 16
1. Date |  |  |  | 2013-01-27 00:00:00 | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2013-03-31 00:00:00 | 2013-04-07 00:00:00 | 2013-04-14 00:00:00 | 2013-04-21 00:00:00 | 2013-04-28 00:00:00 | 2013-05-05 00:00:00 | 2013-05-12 00:00:00 | 2013-05-19 00:00:00
2.  Employment / Internship  Hours |  |  | Mon
 |  |  | Tue
 |  |  | Wed
 |  |  | Thurs
 |  |  | Fri
 |  |  | Sat
 |  |  | Sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 |  |  | Week Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3.   I verify that the dates and hours indicated above have been accomplished by this student:
 |  | Total Hours Worked / Interned Session: |  |  |  |  |  |  |  | 0
Supervisor's / Mentor's  Signature
 |  |  |  |  |  |  | Date
Spreadsheet: 270728d1381611159-index-match-one-step-away-multi-branch-dead-stock-look-up
Sheet: Sheet2

BIR | =
DEN | =
DFW | = | HOU | SAT | OKC | MON | TUL | MON | LIT | HRL | NSH | KSC | BIR | RIC | STA | DEN
HOU | =
HRL | =
KSC | =
LIT | =
MON | = | LIT | DFW | HOU | BIR | NSH
NSH | =
OKC | = | TUL | DFW | KSC | SPF | HOU | SAT | HRL | LIT | MON | NSH | BIR | RIC | STA | DEN
RIC | =
SAT | =
SPF | =
STA | =
TUL | = | OKC | SPF | KSC | LIT | MON | DFW | HOU | SAT | HRL | NSH | BIR | RIC | STA | DEN
Spreadsheet: 263124d1378385777-simple-column-formula-should-be-anyway-but-drawing-a-blank-sam-example
Sheet: Sheet1

1
13
25
37
49
61
73
85
97
109
121
133
145
157
169
181
193
205
217
229
Spreadsheet: 50588d1250060518-excel-to-database-sample-to-database-data
Sheet: Quotation

 | .
 | Quotation: Radio Communication Equipment and Accessories.
 | .
 | Dear Sir/Madam,
 | Thank you for your inquiry re above equipment. I am pleased to quote as follows:
 | . |  | Customer_ID | 5
 | To: |  | Name | E |  | Date: | 2009-05-05 00:00:00
 | . |  | Address | AF | Quotation ref. No.: |  | AA/5 | Just change the Qutation Ref. No.
 | . |  | P.O. BOX | A15 |  | Enquiry No.: | EN-5
 | . |  | Lusaka | 0 |  | KR-REF: | 5
 |  |  | Phone: | 12349
 |  |  | Fax: | 11593
 | Total Items: | 1
 | Item No. | Qty | Description |  |  | Unit Price US$ | Total US$
1 | 1 | 1 | Motorola [NAME] mobile/base VHF radio, 8 channel with scan, 45 watt power output and including microphone, mounting bracket and DC power cable. |  |  | 403 | 403
2
3
4
 | . |  |  |  |  | Subtotal US$ | 403
 | . |  |  |  |  | Discount %
 | . |  |  |  |  | VAT 17.5% US$ | 70.52499999999999
 |  |  |  |  |  | TOTAL US$ | 473.525
 | . |  |  |  |  | [NAME] (Errors and Omissions Excepted)
 | .
Spreadsheet: 37087d1235045403-add-info-from-a-cell-with-a-specific-value-example-1-2003-format
Sheet: Sheet1

ORDER DETAILS |  |  |  |  |  |  |  | ORDER DETAILS
------------- |  |  |  |  |  |  |  | -------------
 |  |  |  |  |  |  |  | Order Number: [NAME]
 |  |  |  |  |  |  |  | Order Date: 18 February 2009
 |  |  |  |  |  |  |  | Order Time:18:02
 |  |  |  |  |  |  |  | CUSTOMER DETAILS
 |  |  |  |  |  |  |  | -------------
 |  |  |  |  |  |  |  | Name: [NAME]
 |  | Despatch Address |  |  |  |  |  | Surname: Jones
 |  | Name | Surname |  |  |  |  | [NAME]: [EMAIL]
 |  | Address 1 |  |  |  |  |  | Address1: Dunhill Road
 |  | Address 2 |  |  |  |  |  | Address2: Bridge Farm Road
 |  | City |  |  |  |  |  | City: Uckfield
 |  | County |  |  |  |  |  | County: East Sussex
 |  | Postcode |  |  |  |  |  | [NAME]: TN22 5AL
 |  |  |  |  |  |  |  | Phone: 01825 763 087
 |  |  |  |  |  |  |  | Fax:
 |  |  |  |  |  |  |  | Order details:
 |  |  |  |  |  |  |  | -------------
 |  |  |  |  |  |  |  | 1122). Funky Star Shoe Laces Price: 1.49, [NAME]:Length 120cm / Width 1cm, [NAME]: White
 |  |  |  |  |  |  |  | Delivery : 1.00
 |  |  |  |  |  |  |  | Total: £3.49
Spreadsheet: 182832d1348628274-excel-bar-chart-dummy-chart
Sheet: Sheet1

 |  |  | IN MINUTE |  | BASIC PROCESS TIME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVER TIME
[NAME] | QTY | PROCESSES / ACTIVITIES | ESTIMATED TIME | TOTAL TIME | 8:00 - 9:00 |  |  |  | 9:00 - 10:00 |  |  |  | 10:00 - 11:00 |  |  |  | 11:00 - 12:00 |  |  |  | 12:00 - 1:00 |  |  |  | 1:00 - 2:00 |  |  |  | 2:00 - 3:00 |  |  |  | 4:00 - 5:00 |  |  |  | 5:00 - 6:00 |  |  |  | 6:00 - 7:00 |  |  |  | 8:00 - 9:00 |  |  |  | 9:00 - 10:00 |  |  |  | 10:00 - 11:00 |  |  |  | 11:00 - 12:00
A | 2 | DRILLING | 20 | 40 | START |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LUNCH BREAK |  |  |  |  |  |  |  | HIGH TEA
B | 5 | TEMPERING | 15 | 75
C | 10 | CUTTING | 30 | 300
D | 4 | DRILLING | 20 | 80
E | 3 | TEMPERING | 15 | 45
F | 2 | DRILLING | 20 | 40
G | 5 | CUTTING | 30 | 150
 | MAN
 |  | BRITNEY SPEARS
 |  | CHRISTINA AGUILERA
 |  | MADONNA
Spreadsheet: 94895d1294667604-formula-to-calculate-from-a-different-sheet-ipr
Sheet: IPR

Sl No | Date | Case Type | [NAME] | Status | Remarks
1 | 2011-01-01 00:00:00 | Sample Type 1 |  | Referral
2 | 2011-01-01 00:00:00 | Sample Type 2
3 | 2011-01-01 00:00:00 | Sample Type 3
4 | 2011-01-01 00:00:00 | Sample Type 5
5 | 2011-01-01 00:00:00 | Sample Type 49
6 | 2011-01-01 00:00:00 | Sample Type 46
7 | 2011-01-01 00:00:00 | Sample Type 4
8 | 2011-01-01 00:00:00 | Sample Type 1
9 | 2011-01-01 00:00:00 | Sample Type 2
10 | 2011-01-01 00:00:00 | Sample Type 3
11 | 2011-01-01 00:00:00 | Sample Type 6
12 | 2011-01-01 00:00:00 | Sample Type 45
13 | 2011-01-01 00:00:00 | Sample Type 6
1 | 2011-01-02 00:00:00 | Sample Type 7
2 | 2011-01-02 00:00:00 | Sample Type 47
3 | 2011-01-02 00:00:00 | Sample Type 11
4 | 2011-01-02 00:00:00 | Sample Type 15
5 | 2011-01-02 00:00:00 | Sample Type 21
6 | 2011-01-02 00:00:00 | Sample Type 21
7 | 2011-01-02 00:00:00 | Sample Type 23
8 | 2011-01-02 00:00:00 | Sample Type 30
9 | 2011-01-02 00:00:00 | Sample Type 31
10 | 2011-01-02 00:00:00 | Sample Type 32
1 | 2011-01-03 00:00:00 | Sample Type 6
2 | 2011-01-03 00:00:00 | Sample Type 45
3 | 2011-01-03 00:00:00 | Sample Type 6
4 | 2011-01-03 00:00:00 | Sample Type 7
5 | 2011-01-03 00:00:00 | Sample Type 21
6 | 2011-01-03 00:00:00 | Sample Type 23
7 | 2011-01-03 00:00:00 | Sample Type 30
8 | 2011-01-03 00:00:00 | Sample Type 31
9 | 2011-01-03 00:00:00 | Sample Type 49
10 | 2011-01-03 00:00:00 | Sample Type 46
11 | 2011-01-03 00:00:00 | Sample Type 4
12 | 2011-01-03 00:00:00 | Sample Type 1
Spreadsheet: 681771d1591734802-sumifs-for-horizontal-and-vertical-criteria-test
Sheet: Sheet1

 |  | Q1 | Q2 | Q3 | Q4 | Total |  | What I need
CNN | ALABEL_CONT | 315480.24210288 | 1135165.754609993 | 1071306.625136332 | 667796.802792415 |  |  | CNN | ALABEL_CONT | Q1
CNN | COGS_CC | 55207.44856978 | 160759.3861043007 | 93302.44596697259 | 88920.7411886433 |  |  | CNN | ALABEL_CONT | Q2
 |  |  |  |  |  |  |  | CNN | ALABEL_CONT | Q3 | 1071306.625136332
FP&A | BLABEL_CONT | 0.3648460706249971 | 0.3648460706249971 | 0.3980660706250019 | 0.401199710625 |  |  | CNN | ALABEL_CONT | Q4 | 667796.802792415
FP&A | COGS_CC | 1.459384282499988 | 1.459384282499988 | 1.592264282500008 | 1.6047988425 |  |  | CNN | COGS_CC | Q1 | 55207.44856978
 |  |  |  |  |  |  |  | CNN | COGS_CC | Q2 | 160759.3861043007
 |  |  |  |  |  |  |  | CNN | COGS_CC | Q3 | 93302.44596697259
 |  |  |  |  |  |  |  | CNN | COGS_CC | Q4 | 88920.7411886433
 |  |  |  |  |  |  |  | FP&A | BLABEL_CONT | Q1 | 0.3648460706249971
 |  |  |  |  |  |  |  | FP&A | BLABEL_CONT | Q2 | 0.3648460706249971
 |  |  |  |  |  |  |  | FP&A | BLABEL_CONT | Q3 | 0.3980660706250019
 |  |  |  |  |  |  |  | FP&A | BLABEL_CONT | Q4 | 0.401199710625
 |  |  |  |  |  |  |  | FP&A | COGS_CC | Q1 | 1.459384282499988
 |  |  |  |  |  |  |  | FP&A | COGS_CC | Q2 | 1.459384282499988
 |  |  |  |  |  |  |  | FP&A | COGS_CC | Q3 | 1.592264282500008
 |  |  |  |  |  |  |  | FP&A | COGS_CC | Q4 | 1.6047988425
Spreadsheet: 268541d1380678091-formula-to-show-quantities-for-amount-entered-test
Sheet: Sheet1

 |  |  |  |  |  | Code | Description | Req'd Qty
 |  |  |  |  |  | 1 | type 1 | 5.34
 |  |  |  |  |  | 2 | type 2 | 11.26
 |  |  |  |  |  | 3 | type 3 | 4.1
 |  |  |  |  |  | 4 | type 4 | 6.5
 |  |  |  |  |  | 5 | type 5 | 12.96
 |  |  |  |  |  | 6 | type 6 | 4.02
 |  |  |  |  |  | 7 | type 7 | 5.58
 |  |  |  |  |  | 8 | type 8 | 30.83
 |  |  |  |  |  | 9 | type 9 | 9.298
 |  |  |  |  |  | 10 | type 10 | 25.52
 |  |  |  |  |  | 11 | type 11 | 2.79
 |  |  |  |  |  | 12 | type 12 | 0.4
 |  |  |  |  |  | 13 | type 13 | 2.52
 |  |  |  |  |  | 14 | type 14 | 2.83
 |  |  |  |  |  | 15 | type 15 | 1.66
 |  |  |  |  |  | 16 | type 16 | 2.3
 |  |  |  |  |  | 17 | type 17 | 0.13
 |  |  |  |  |  | 18 | type 18 | 871.962
 |  |  |  |  |  |  | NEW PRODUCT
Spreadsheet: dc64df19-fed3-4b34-b3fc-972f2c9c782f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | CITRIX SYSTEMS, INC.
 | NET REVENUES BY REPORTABLE SEGMENT
 | (In thousands)
 |  |  | Three Months |  | Three Months |  | Three Months |  | Three Months |  | Twelve Months
 |  |  | Ended |  | Ended |  | Ended |  | Ended |  | Ended
 |  |  | March 31, |  | June 30, |  | September 30, |  | December 31, |  | December 31,
 |  |  | 2010 |  | 2010 |  | 2010 |  | 2010 |  | 2010
 | Net Revenues:
 | Enterprise Division |  | 329322 |  | 369222 |  | 380573 |  | 434928 |  | 1514045
 | Online Services Division |  | 84950 |  | 89211 |  | 91660 |  | 94796 |  | 360617
 | Total net revenues |  | 414272 |  | 458433 |  | 472233 |  | 529724 |  | 1874662
 | Note:  This document should be read in conjunction with the Company's SEC Filings.
Spreadsheet: 7f8c103d-d9e5-4f83-ada6-bc4dcd054959
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
HCVG | Test | HCVG | Hepatitis C Virus Genotype, Serum | HCV [NAME], S | Reverse Transcriptase-Polymerase Chain Reaction (RT-PCR) (PCR is utilized pursuant to a license agreement with Roche Diagnostic Systems, Inc.) | Serum Gel Tube: SGT OR |  |  | 1.5 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL  Collection Instructions: 1. Spin down and separate serum from gel within 6 hours of collection. 2. Freeze serum immediately and ship specimen frozen on dry ice. 3. If shipment will be delayed for >24 hours, freeze serum at [NAME] (up to 35 days) until shipment on dry ice. Additional Information: Specimens should contain a recommended minimum HCV viral load of 1,000 IU/mL. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold <24 hours OK, refreeze with note to laboratory Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Heparinized specimen, red top tube, plasma | Undetected | Monday through Friday; 8 a.m. | 3 days | 6 days | 1 | 87902 |  |  |  |  | Rochester
HCVG | [NAME] | SST | Serum SST |  |  |  | Frozen
HCVG | Result | 81618 | HCV [NAME], S | HCV [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32286-7
Spreadsheet: 181230d1347972345-histogram-from-a-pivot-table-plot-empty-bins-as-having-frequency-0-example
Sheet: Sheet1

Total | Material |  |  | Count of Total | Column Labels
12 | Aluminium |  |  | Row Labels | Aluminium | Copper | Zinc | Grand Total
98 | Aluminium |  |  | <1 | 0 | 0 | 0 | 0
94 | Aluminium |  |  | 1-5 | 0 | 0 | 0.1111111111111111 | 0.03703703703703703
22 | Aluminium |  |  | 6-10 | 0 | 0 | 0 | 0
27 | Aluminium |  |  | 11-15 | 0.1111111111111111 | 0 | 0.3333333333333333 | 0.1481481481481481
39 | Aluminium |  |  | 16-20 | 0 | 0.4444444444444444 | 0.1111111111111111 | 0.1851851851851852
73 | Aluminium |  |  | 21-25 | 0.1111111111111111 | 0.1111111111111111 | 0.1111111111111111 | 0.1111111111111111
88 | Aluminium |  |  | 26-30 | 0.1111111111111111 | 0 | 0 | 0.03703703703703703
91 | Aluminium |  |  | 31-35 | 0 | 0.2222222222222222 | 0 | 0.07407407407407407
42 | Copper |  |  | 36-40 | 0.1111111111111111 | 0 | 0.2222222222222222 | 0.1111111111111111
20 | Copper |  |  | 41-45 | 0 | 0.2222222222222222 | 0.1111111111111111 | 0.1111111111111111
18 | Copper |  |  | 46-50 | 0 | 0 | 0 | 0
33 | Copper |  |  | 51-55 | 0 | 0 | 0 | 0
44 | Copper |  |  | 56-60 | 0 | 0 | 0 | 0
34 | Copper |  |  | 61-65 | 0 | 0 | 0 | 0
17 | Copper |  |  | 66-70 | 0 | 0 | 0 | 0
19 | Copper |  |  | 71-75 | 0.1111111111111111 | 0 | 0 | 0.03703703703703703
22 | Copper |  |  | 76-80 | 0 | 0 | 0 | 0
21 | Zinc |  |  | 81-85 | 0 | 0 | 0 | 0
38 | Zinc |  |  | 86-90 | 0.1111111111111111 | 0 | 0 | 0.03703703703703703
12 | Zinc |  |  | 91-95 | 0.2222222222222222 | 0 | 0 | 0.07407407407407407
1 | Zinc |  |  | 96-100 | 0.1111111111111111 | 0 | 0 | 0.03703703703703703
12 | Zinc |  |  | >101 | 0 | 0 | 0 | 0
36 | Zinc |  |  | Grand Total | 1 | 1 | 1 | 1
15 | Zinc
43 | Zinc
18 | Zinc
Spreadsheet: 03278f26-751d-4784-99f9-2b4d5c7c9aa4
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Faculty of Mathematics and Sciences
Study Year | Major [NAME] |  |  |  | Enrolment Headcount
 |  | 1999-00 | 2000-01 | 2001-02 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09
 | Single | 243 | 238 | 187 | 228 | 503 | 537 | 426 | 350 | 421 | 405
 | Combined | 3 | 4 | 6 | 4 | 2 | 6 | 6 | 11 | 7 | 6
Year I | Sub-Total: | 246 | 242 | 193 | 232 | 505 | 543 | 432 | 361 | 428 | 411
 | Gen/Integ Studies | 11 | 49 | 37 | 39 | 49 | 24 | 43 | 59 | 83 | 65
 | Total: | 257 | 291 | 230 | 271 | 554 | 567 | 475 | 420 | 511 | 476
 | Single | 253 | 292 | 287 | 251 | 239 | 371 | 370 | 316 | 252 | 297
 | Combined | 16 | 11 | 10 | 16 | 8 | 15 | 17 | 15 | 14 | 12
Year II | Sub-Total: | 269 | 303 | 297 | 267 | 247 | 386 | 387 | 331 | 266 | 309
 | Gen/Integ Studies | 10 | 30 | 38 | 35 | 28 | 28 | 19 | 35 | 50 | 34
 | Total: | 279 | 333 | 335 | 302 | 275 | 414 | 406 | 366 | 316 | 343
 | Single | 376 | 318 | 312 | 303 | 246 | 202 | 302 | 297 | 235 | 182
 | Combined | 39 | 30 | 30 | 22 | 21 | 17 | 22 | 22 | 19 | 17
Year III | Sub-Total: | 415 | 348 | 342 | 325 | 267 | 219 | 324 | 319 | 254 | 199
 | Gen/Integ Studies | 26 | 23 | 45 | 38 | 42 | 37 | 38 | 21 | 35 | 37
 | Total: | 441 | 371 | 387 | 363 | 309 | 256 | 362 | 340 | 289 | 236
 | Single | 77 | 144 | 154 | 172 | 192 | 113 | 103 | 191 | 211 | 163
 | Combined | 17 | 22 | 14 | 16 | 19 | 8 | 8 | 20 | 18 | 19
Year IV | Sub-Total: | 94 | 166 | 168 | 188 | 219 | 121 | 111 | 211 | 229 | 182
 | Gen/Integ Studies | 2 | 46 | 37 | 33 | 52 | 39 | 31 | 40 | 34 | 42
 | Total: | 96 | 212 | 205 | 221 | 271 | 160 | 142 | 251 | 263 | 224
 | Single | 949 | 992 | 940 | 954 | 1180 | 1223 | 1201 | 1154 | 1119 | 1047
 | Combined | 75 | 67 | 60 | 58 | 50 | 46 | 53 | 68 | 58 | 54
TOTAL: | Sub-Total: | 1024 | 1059 | 1000 | 1012 | 1230 | 1269 | 1254 | 1222 | 1177 | 1101
 | Gen/Integ Studies | 49 | 148 | 157 | 145 | 171 | 128 | 131 | 155 | 202 | 178
 | Total: | 1073 | 1207 | 1157 | 1157 | 1401 | 1397 | 1385 | 1377 | 1379 | 1279
 | Adjusted Total: | 1021 | 1176 | 1137 | 1136 | 1401 | 1397 | 1385 | 1377 | 1379 | 1279
Male |  |  | 711 | 700 | 699 | 793 | 789 | 761 | 746 | 732 | 710
Female |  |  | 496 | 457 | 458 | 608 | 608 | 624 | 631 | 647 | 569
Full-Time |  |  | 997 | 924 | 934 | 1190 | 1192 | 1195 | 1181 | 1199 | 1119
Part-Time |  |  | 210 | 233 | 223 | 211 | 205 | 190 | 196 | 180 | 160
Spreadsheet: 812474d1673180299-help-with-copying-the-formulas-across-the-row-to-a-column-sample-book
Sheet: Sheet1

 |  | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2023-01-14 00:00:00 | 2023-01-15 00:00:00
 | A | 5000 |  |  | 8000 | 5000 |  |  | 8000 | 5000 |  |  | 8000 |  |  | 5000
 | B | 6500 | 2500 |  | 1500 | 6500 | 2500 |  | 1500 | 6500 | 2500 |  | 1500 | 2500 |  | 6500
 | C |  |  | 3000 | 2500 |  |  | 3000 | 2500 |  |  | 3000 | 2500 |  | 3000
 | D |  | 7000 |  | 10000 |  | 7000 |  | 10000 |  | 7000 |  | 10000 | 7000
 | E |  |  | 5000 | 7000 |  |  | 5000 | 7000 |  |  | 5000 | 7000 |  | 5000
 | F |  |  | 6000 | 50000 |  |  | 6000 | 50000 |  |  | 6000 | 50000 |  | 6000
 | G |  |  |  | 32 |  |  |  | 32 |  |  |  | 32
 | 2023-01-01 00:00:00
 | 2023-01-02 00:00:00
 | 2023-01-03 00:00:00
 | 2023-01-04 00:00:00
 | 2023-01-05 00:00:00
 | 2023-01-06 00:00:00
 | 2023-01-07 00:00:00
 | 2023-01-08 00:00:00
 | 2023-01-09 00:00:00
 | 2023-01-10 00:00:00
 | 2023-01-11 00:00:00
 | 2023-01-12 00:00:00
 | 2023-01-13 00:00:00
 | 2023-01-14 00:00:00
 | 2023-01-15 00:00:00
 | How can create a dynamic formula in cells C13 to c27 so that any changes in the table above reflects in the coloumn values in c13 - c27
 | In this instance I have manullay keyed in the formula's in c13-c16, I want to extend the formula's to 05/01/2023 to 15/01/2023 without having to manually key in the formula in every coloumn cell