tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18573__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 811588d1672671199-formula-to-extract-a-part-of-text-new-microsoft-excel-worksheet
Sheet: Sheet1

Column1 | Expected Results | Ctrl+E | Text Before Delimiter
G01) Aniqa, ( | G01 | G01 | G01
G02) [NAME], (f138 | G02 | G02 | G02
G03) Aiman [NAME], (f055 | G03 | G03 | G03
G04) [NAME], ( | G04 | G04 | G04
Spreadsheet: 219566d1362786614-autopopulate-formula-from-two-columns-of-data-copy3-of-amc-2013-budget
Sheet: FEB - Report

Allenmore Men's Club                                                        Treasurers Report  -  February 2013
Starting Balance: | 304
Monthly Income: | 4690
Monthly Expenses: | 44
Ending Balance: | 4950
Change: | 4646
Receipts since last report:
 |  |  | Total Receipts:
Dispursements:
 |  |  | Total Dispursements:
Special Notes:
Prepared By: | Secretary/Treasurer |  | Accepted By:
 | [NAME]
 |  |  | ü | Allenmore Men's Club
 |  |  | ü | General Meeting
 | Signature |  | ü | Membership in Attendance
 |  |  | ü | Passed & Recorded
 |  | Date |  | into Minutes
Spreadsheet: 31555d1227441850-excel-2007-excel-counting-formula-new-formula-2007
Sheet: Sheet1

item |  | Amari board price | [NAME] | length [NAME] | cost price | extra cost | price | inc vat |  | discount | sub total | qty | TOTAL | SUPPLY | INC VAT
FOAMEX | 3MM | 23 | 1200 | 600 |  |  |  |  |  |  |  | 1
FOAMEX | 5MM | 28.27 | 1200 | 2400 |  |  |  |  |  |  |  | 1
FOAMEX | 10MM | 57 | 600 | 900 |  |  |  |  |  |  |  | 0
FOAMEX | 19MM | 71 | 1220 | 2400 |  |  |  |  |  |  |  | 0
DIBOND | 3MM | 68 | 1200 | 2400 |  |  |  |  |  |  |  | 0
CORREX | 6MM | 6 | 600 | 900 |  |  |  |  |  |  |  | 1 |  |  |  | FOR 2 OR MORE
PERSPEX | 3mm | 68 | 1200 | 2400 |  |  |  |  |  |  |  | 1
digital print | vinyl | 24 | 1000 | 1000 |  |  |  |  |  |  |  | 1
REFLECTIVE VINYL | vinyl | 20 | 1000 | 1000 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 175
 | HEM & EYE | banner cost | [NAME] | length [NAME] | BANNER | TOTAL | PRICE | PRICE INC VAT
HD BANNER |  | 24 | 1800 | 1000 |  |  |  |  |  |  |  | 1
BANNER |  | 15 | 1800 | 1000 |  |  |  |  |  |  |  | 1
 |  |  | full cover | 2 sides | 2 sides + bk |  | 2 sides +fr | back | front | supply only | supply only |  | TOTAL | VAT
RECOVERY TRUCK
BOAT
TRUCK
TRAILER
LWB VAN
SWB VAN
TRANSIT
HORSE BOX
CONNECT SIZE
TAXI
CAR
bus/coach
Spreadsheet: 888619d1739195241-how-to-calculate-the-median-example
Sheet: Tabelle1

 |  |  |  | Scale | Answers
 |  |  | Fully disagree | 1 | 3
 |  |  |  | 2 | 1
 |  |  |  | 3 | 1
 |  |  |  | 4 | 2
 |  |  |  | 5 | 3
 |  |  |  | 6 | 5
 |  |  |  | 7 | 7
 |  |  |  | 8 | 6
 |  |  |  | 9 | 2
 |  |  | Fully agree | 10 | 1
 |  |  |  | Median | ?
Spreadsheet: 768945d1645209661-gantt-chart-conditional-formatting-example-gnatt
Sheet: Sheet1

 | PROJECT START: | 2022-02-01 00:00:00
 | Display Week: | 1
Project | Progress | START | END
 |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
Updated: 1/24/2022
Completed
ITEM EXAMPLE 1 | 1 | 2021-10-26 00:00:00 | 2022-01-31 00:00:00
[NAME] | 1 | 2021-11-02 00:00:00 | 2022-02-07 00:00:00
ITEM EXAMPLE 3 | 1 | 2021-10-26 00:00:00 | 2021-11-01 00:00:00
[NAME] | 1 | 2022-01-31 00:00:00 | 2022-02-03 00:00:00
ITEM EXAMPLE 5 | 1 | 2021-11-02 00:00:00 | 2022-02-07 00:00:00
ITEM EXAMPLE 6 | 1 | 2021-10-26 00:00:00 | 2021-11-01 00:00:00
ITEM EXAMPLE 7 | 1 | 2022-01-31 00:00:00 | 2022-02-03 00:00:00
ITEM EXAMPLE 8 | 1 | 2021-11-02 00:00:00 | 2022-02-07 00:00:00
ITEM EXAMPLE 9 | 1 | 2021-10-26 00:00:00 | 2021-11-01 00:00:00
ITEM EXAMPLE 10 | 1 | 2022-01-31 00:00:00 | 2022-02-03 00:00:00
ITEM EXAMPLE 11 | 1 | 2021-10-26 00:00:00 | 2022-01-31 00:00:00
ITEM EXAMPLE 12 | 1 | 2021-12-16 00:00:00 | 2022-01-19 00:00:00
ITEM EXAMPLE 13 | 1 | 2021-12-23 00:00:00 | 2022-01-19 00:00:00
ITEM EXAMPLE 14 | 1 | 2021-12-16 00:00:00 | 2022-01-19 00:00:00
ITEM EXAMPLE 15 | 1 | 2021-12-10 00:00:00 | 2021-12-24 00:00:00
ITEM EXAMPLE 16 | 1 | 2021-12-08 00:00:00 | 2021-12-15 00:00:00
[NAME] | 1 | 2021-11-29 00:00:00 | 2021-12-09 00:00:00
[NAME] 18 | 1 | 2021-11-29 00:00:00 | 2021-12-14 00:00:00
Spreadsheet: 92258d1291883540-calculate-pro-rata-share-of-two-variables-challenge
Sheet: HowMuch

HOW MUCH SHOULD EACH INVESTOR GET?
Assume disbursements are only made once per year, after the year has ended
(All user input fields (variables) are in pink)
STEP 1: Capital Share |  |  |  | STEP 2: Time of Capital Invested |  |  |  |  | STEP 3: How much should each Investor Get?
 | Capital Contribution | % of Total Capital Contributed by Each Member |  |  | Date of Capital Contribution | # Days Capital Contribution Vested | % of Of the Year Contribution Vested |  |  | [NAME] of Year Total Payout | Total End of Year Earnings
[NAME] | 75000 |  |  | [NAME] | 2011-01-01 00:00:00 |  |  |  | [NAME] | ? | 20000
[NAME] | 25000 |  |  | [NAME] | 2011-07-01 00:00:00 |  |  |  | [NAME] | ?
Total Contributions |  |  |  | Total Days of Vested Contributions |  | 365
MY INITIAL TRAIN OF THOUGHT: This is what I started with, but it is not correct. If you set the [NAME] all equal, and the Capital Contribution as I have done below, you will see that Investor A gets 8.3k. But he contributed 50% of the total capital...so he should be getting 10k (assuming they all invested at the same time). Clearly I lack the math skills to do this computation properly.
 | Capital Contribution | % of Total Capital Contributed by Each Member | Capital Payout Factor |  | Date of Capital Contribution | # Days Capital Contribution Vested | % of Total Days Vested by Each Member | Time Payout Factor |  | End of Year Total Payout | Total End of Year Earnings
Investor A | 100000 |  |  |  | 2011-01-01 00:00:00 |  |  |  |  |  | 20000
Investor B | 50000 |  |  |  | 2011-01-01 00:00:00
Investor C | 50000 |  |  |  | 2011-01-01 00:00:00
Total Contributions |  |  |  |  | Total Days of Vested Contributions
Spreadsheet: 83650d1283630933-copying-data-from-one-sheet-to-another-2010itemizedsample
Sheet: Expense report

Index | Type Entity Name in yellow portion |  | Sample report
 | Year: | 2010 | Month: | 4
 | Sample report  Expense Report
 | April-2010
 | Date |  | Item |  | Amount
2
3 | 2010-04-02 00:00:00 |  | cut grass |  | 90
4 | 2010-04-05 00:00:00 |  | Vacuum bags |  | 11.84
5 | 2010-04-13 00:00:00 |  | Cleaning supplies |  | 11.18
6 | 2010-04-14 00:00:00 |  | Lowes Home Center, board for table top |  | 13.18
7 | 2010-04-15 00:00:00 |  | cut grass |  | 90
8 | 2010-04-15 00:00:00 |  | Wasp spray |  | 5.97
9 | 2010-04-15 00:00:00 |  | So. States – mulch |  | 12.9
10 | 2010-04-16 00:00:00 |  | cut grass |  | 125
11 | 2010-04-22 00:00:00 |  | Plant hooks, [NAME] |  | 13.14
12 | 2010-04-29 00:00:00 |  | cut grass |  | 90
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80 |  | TOTAL: |  |  | 463.21
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
Spreadsheet: 191082d1351893360-sticky-lookup-or-nested-if-please-help-deadline-sample-workbook
Sheet: Data

TCV | Sales $0-$1.8m | Sales $1.8-$2.5m | Sales $2.5-$3 | Sales $3-$3.5 | Sales $3.5-max
185000 | *all of these columns need to return the TCV that falls within the given range
300000 | up to the point that the sum of these TCVs is greater than 1.8m. At this point
45000 | and in the remaining rows (D,E,F), the TCV needs to be returned only if this
71000 | threshold has been reached.
50000
125000
8750
8750
8750
8750
12500
5000
1500
450
2500
17500
221000
110750
15000
550
20000
12500
2500
3000
1500
584000
150000
30000
2000
2500
2500
800
666750
225000
265000
180000
180000
250000
50000
140000
302250
450
500
Spreadsheet: 226192d1365279316-progressive-lottery-checker-progressive-lottery-draw-3
Sheet: Players Numbers

 | [NAME] Style Progressive Draw Checker
 | Each person playing in this group lottery has chosen their own 6 (six) number combination from 1 to 49. The lottery will run until atleast one person has had all 6 (six) of their number drawn excluding bonus numbers. The bonus numbers drawn do not count towards any of the numbers picked unless they are part of the regular numbers drawn on each draw. Once a player/players has all their numbers picked then at that time there will be a winner determined.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Numbers Drawn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw Date | Numbers
 | Players Name | Numbers Selected |  |  |  |  |  |  | Players Name | Numbers Selected |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 1 | 12 | 14 | 24 | 32 | 46
 | [NAME] | 3 | 14 | 18 | 24 | 46 | 47 |  |  |  |  |  |  |  |  |  |  | 2012-02-15 00:00:00 | 8 | 9 | 18 | 31 | 45 | 49
 | [NAME] | 7 | 15 | 32 | 38 | 40 | 45 |  |  |  |  |  |  |  |  |  |  | 2012-03-12 00:00:00 | 47 | 15 | 38 | 40 | 16 | 21
 | [NAME] | 12 | 16 | 22 | 24 | 33 | 44 |  |  |  |  |  |  |  |  |  |  | 2012-04-12 00:00:00 | 33 | 44 | 41 | 37 | 30 | 1
 | [NAME] | 11 | 17 | 30 | 37 | 41 | 46
Spreadsheet: 268308d1380559370-salary-calculation-my-requirements
Sheet: Sheet1

 |  |  |  | Actual salary | Basic Salary | Workind Days | Days Worked | Amount
 |  |  | example 1 | 260 | 200 | 26 | 25 | 190 | perfect reply
 |  |  | example 2 | 260 | 200 | 26 | 26 | 200 | perfect reply
 |  |  | example 3 | 260 | 200 | 26 | 1 | -50 | [NAME]..I want here reply 10 not -50, because if we calculate salary (200/26*1=7.69) is smaller than (260/26*1=10)..
Spreadsheet: 761904d1641293197-creating-3-dependent-drop-down-lists-dv-named-range-example-dependent-drop-down-lists-aligw
Sheet: Sheet1

Dependent drop-down lists
Category | Big
Level | Fat
Type of work | 2
Category | Level
Big | Fat
B | D
 | E
 | F
Type of work
AD | BD | AC | BC | AE | BE | AF | BF
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4
 | 5 | 5 | 5 | 5 | 5
 | 6 |  | 6
 | 7
 | 8
 | 9
Spreadsheet: 676661d1588921855-to-find-out-company-ranking-issue-rank-model
Sheet: Sheet2

Product | Cost + Duty Wise Company Best | Lowest Price | Company-Origin | Port / Air City | Import Cost | Custom Duty | Forword Cost | Total Duty | Duty Wise Company - Lowest | Rank Price Wise | Rank Total Duty Wise
A | Company-1 |  | USA | New York | 9 | 5 | 2
 | Company-2 | 105 | USA | California | 9.5 | 5 | 2
 | Company-3 | 102 | EU | Germany | 9.5 | 4 | 2
 | Company-4 | 117 | UK | [NAME] | 10 | 5 | 2
B | Company-1 |  | USA | New York | 10 | 5 | 2
 | Company-2 | 112 | USA | California | 9.5 | 4 | 2
 | Company-3 | 115 | EU | Germany | 9 | 5.5 | 2
 | Company-4 | 112 | UK | [NAME] | 10 | 4.5 | 2
C | Company-1 | 110 | USA | New York | 10 | 4.8 | 2
 | Company-2 | 100 | USA | California | 11 | 4.5 | 2
 | Company-3 | 113 | EU | Germany | 10.5 | 5 | 2
 | Company-4 | 115 | UK | [NAME] | 9 | 5.5 | 2
D | Company-1 | 100 | USA | New York | 9.5 | 4.5 | 2
 | Company-2 | 98 | USA | California | 9 | 5 | 2
 | Company-3 | 104 | EU | Germany | 9.5 | 5 | 2
 | Company-4 | 95 | UK | [NAME] | 10 | 4.5 | 2
F | Company-1 | 100 | USA | New York | 10 | 5 | 2
 | Company-2 | 103 | USA | California | 11 | 5.5 | 2
 | Company-3 | 97 | EU | Germany | 11.5 | 5 | 2
 | Company-4 | 97 | UK | [NAME] | 10 | 4.8 | 2
Spreadsheet: 525562d1498772417-formula-to-determine-if-team-member-has-entered-data-this-week-names
Sheet: Sheet1

Name | Date | This Week? | Send reminder?
[NAME] | 2017-06-28 00:00:00
[NAME] | 2017-06-20 00:00:00
[NAME] | 2017-06-10 00:00:00
[NAME] | 2017-06-24 00:00:00
[NAME] | 2017-06-27 00:00:00
Spreadsheet: 747014d1631182087-weekend-call-out-duty-list-call-out-list
Sheet: Call Out List

2021-01-01 00:00:00
2020-01-02 00:00:00 | Bryant |  |  | [NAME] |  |  | Donnell
 | Donnell |  |  | Molnar |  |  | Hardy
 | Hardy |  |  | [NAME] |  |  | Lutz
 | Lutz |  |  | Bryant |  |  | Martin
 | Martin
 | [NAME] | Easter |  | Donnell |  |  | [NAME]
 | Molnar |  |  | Hardy |  |  | Bryant
 | [NAME] |  |  | Lutz |  |  | Donnell
 | Bryant |  |  | Martin |  |  | Hardy
 |  |  |  | Molnar | Memorial
 | Lutz | July 4th |  | Donnell |  |  | Molnar | Labor
 | Martin |  |  | Hardy |  |  | Bryant
 | Molnar |  |  | Yaple |  |  | [NAME]
 | [NAME] |  |  | Martin |  |  | Odutola
 | Bryant
 | Donnell |  |  | Odutola |  |  | Hardy
 | Hardy |  |  | [NAME] |  |  | Yaple
 | Yaple |  |  | Bryant |  |  | Martin
 | Martin |  |  | Donnell | Thanks |  | Molnar | Christmas
 | Molnar |  |  |  |  |  | Odutola
Spreadsheet: 054fc102-52af-44c9-b320-fa17c0778aa0
Sheet: Sheet1

Table 3. [NAME] for Full Time, Year Round Workers 25 Years and [NAME] in the United States by Gender and Education Level, 2005 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Median Annual Earnings ($)
 | By Education Level
 | All |  | White |  | African American |  | Asian American |  | Native American |  | Hispanic
 | Women | Men | Women | Men | Women | Men | Women | Men | Women | Men | Women | Men
Less than High School Diploma | 19400 | 26500 | 21600 | 32600 | 20400 | 25500 | 20400 | 25500 | 18300 | 27300 | 17300 | 22400
High School Diploma/GED | 26500 | 35700 | 27500 | 39100 | 24400 | 30600 | 25500 | 30600 | 24400 | 32600 | 23400 | 28500
Some College | 30800 | 42800 | 32600 | 45800 | 30600 | 36700 | 32100 | 38700 | 28500 | 37700 | 30600 | 36700
Associate's Degree | 35700 | 45800 | 36700 | 47900 | 33600 | 40700 | 36700 | 40700 | 32600 | 39700 | 31600 | 40700
Bachelor's Degree | 44800 | 61100 | 45800 | 63200 | 40700 | 48900 | 46700 | 59100 | 38700 | 49900 | 40700 | 46900
[NAME] | 56000 | 81500 | 57000 | 86600 | 53000 | 61100 | 63200 | 81500 | 46900 | 68300 | 50900 | 65200
Notes: Racial categories white, African American, and Asian American do not include Hispanics. Hispanics may be of any race. The category Asian American includes Native Hawaiians/Pacific Islanders.
Source: U.S. Department of Commerce, Bureau of the Census, 2005 American Community Survey.
Tabulated by the Urban Institute for the Institute for Women's Policy Research.
Spreadsheet: 784794d1655962349-get-applicable-interest-rate-for-a-given-period-fiscal-year-adjustments-aligw
Sheet: Expenditure P90_P50

 | Expenditure Profile P90: |  |  |  | 2022-03-01 00:00:00 | 2022-06-01 00:00:00 | 2022-09-01 00:00:00 | 2022-12-01 00:00:00 | 2023-03-01 00:00:00 | 2023-06-01 00:00:00 | 2023-09-01 00:00:00 | 2023-12-01 00:00:00 | 2024-03-01 00:00:00 | 2024-06-01 00:00:00 | 2024-09-01 00:00:00 | 2024-12-01 00:00:00 | 2025-03-01 00:00:00 | 2025-06-01 00:00:00 | 2025-09-01 00:00:00 | 2025-12-01 00:00:00 | 2026-03-01 00:00:00 | 2026-06-01 00:00:00 | 2026-09-01 00:00:00 | 2026-12-01 00:00:00 | 2027-03-01 00:00:00 | 2027-06-01 00:00:00 | 2027-09-01 00:00:00 | 2027-12-01 00:00:00 | 2028-03-01 00:00:00 | 2028-06-01 00:00:00 | 2028-09-01 00:00:00 | 2028-12-01 00:00:00
 |  |  |  |  | period 0* | period 1* | period 2 | period 3 | period 4 | period 5 | period 6 | period 7 | period 8 | period 9 | period 10 | period 11 | period 12 | period 13 | period 14 | period 15 | period 16 | period 17 | period 18 | period 19 | period 20 | period 21 | period 22 | period 23 | period 24 | period 25 | period 26 | period 27
 | Adjustment factors
 | Year | Per Year
 | 16/17 | 0.03
 | 17/18 | 0.04
 | 18/19 | 0.026
 | 19/20 | 0.035
 | 20/21 | 0.047
 | 21/22 | 0.063
 | 22/23 | 0.038
 | 23/24 | 0.027
 | 24/25 | 0.032
 | 25/26 | 0.031
Spreadsheet: 595438d1540440364-extracting-data-in-rows-extracting-data-in-rows
Sheet: NEEDS TO BE LIKE THIS (2)

 |  | Molybdenum
 |  | Selenium
 |  | Gross-Uranium
 |  | Arsenic
Spreadsheet: 704265d1605468828-can-the-sum-range-of-sumif-be-stopped-and-only-pick-certain-rows-to-sum-help-with-excel-sumif-with-index-match
Sheet: Sheet1

Unique "Text" | Variable | Line Item | TOTALS | Details
S | S |  | 20 | < need formual that sums down from ROW 5 to ROW 20 but will stop at ROW 8. Then only sum the Rows WITHOUT the letter "v" in Column B
blank |  | Line Items 1 | 10
blank |  | Line Items 2 | 10
blank | v | Line Items 3 | 0
blank | v | Line Items 4 | 10
S | S |  | 50 | < need formual that sums down from ROW 10 to ROW 20 but will stop at ROW 15. Then only sum the Rows WITHOUT the letter "v" in Column B
blank |  | Line Items 5 | 20
blank | v | Line Items 6 | 20
blank |  | Line Items 7 | 0
blank |  | Line Items 8 | 20
blank |  | Line Items 9 | 10
blank |  | Line Items 10 | 0
S | S |  | 30 | < need formual that sums down from ROW 17 to ROW 20 but will stop at ROW 19. Then only sum the Rows WITHOUT the letter "v" in Column B
blank | v | Line Items 11 | 0
blank | v | Line Items 12 | 30
blank |  | Line Items 13 | 30
S | S
Spreadsheet: 870571d1717066382-need-to-get-a-summary-of-excel-sheets-main-data-sheet
Sheet: 24018

 | [NAME] (PVT)LTD |  | GOOD RECEIPTS NOTE-STORES |  | PAYMENT VOUCHER COPY
 | VENDOR'S NAME -Sujith Auto Electricals |  | COVERING SRN NO |  | GRN DATE | 15/3/2024
 |  |  |  |  | GRN DATE
 | INVOICE NO -INV52908 |  | GRN NO | 24018 | DATE OF INVOICE | 14/3/2024
 | S/NO: | [NAME] OF ITEM RECEIVED | RECEIVED QTY |  | Unit Price | Amount
 |  |  | Unit | Quantity
 | 1 | relay socket | Nos | 7 | 450
 | 2 | Solder wire Yard | Nos | 2 | 180
 | 3 | 2 Pin socket | Nos | 8 | 190
 | 4 | 4 pin Socket | Nos | 3 | 140
 | 5 | Relay 24V 5 pin 2 | Nos | 7 | 1750
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | ABOVE ITEMS RESEIVED GOOD ,INSPECTED& PREPARED BY    …............................  (Store EXECUTIVE)                DATE:….................................
 | GOODS RECEIVED & TAKEN TO THE STOCKS                        …............................ (Store Manager)                          DATE:….......................................
 | GOODS RESIVED NOTE APPROVED                                      …............................ (Factory Manager)                       DATE:….......................................
Spreadsheet: 877989d1724941866-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-referralexcel-2-
Sheet: Sheet3

REF? | ID | PATIENT | DATE | PROVIDER
 | A234 | BUNNY, B |  | BANNER, B
X | N3456 | FUDD, E |  | WAYNE, B
 | J165 | DUCK, D |  | KENT, C
Z | RT6514 | LE PEW, P | 2024-04-19 00:00:00 | STARK, T
Y | E566 | COYOTE, W | 2024-03-23 00:00:00 | KYLE, S
X | [NAME] | PIG, P |  | QUINN, H
 | [NAME] | GONZALEZ, S | 2024-02-12 00:00:00 | [NAME], D
Spreadsheet: 858888d1707392819-help-sumif-multiple-tabs-example2
Sheet: September

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 104
Name 105
Name 106 |  |  |  |  |  |  |  |  | Done Totals
Name 107 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 108
Name 109
Name 110
Name 111
Name 112
Name 113
Name 114
Name 115
Spreadsheet: 55747d1255952668-multiple-interrogation-of-data-703832_marvick1
Sheet: SUMMARY

 | 2009-12-01 00:00:00 |  |  | 2009-12-01 00:00:00
 | Finance |  |  | Correspondence
 | Winter 2009/2010 |  |  | Winter 2009/2010
 | Cheque |  |  |  |  | these calcs utilise concatenation fields to negate need for expensive SUMPRODUCT / Arrays
ANDORRA | 1200 |  | ANDORRA | 2
AUSTRIA | 3200 |  | AUSTRIA | 3
BULGARIA | 0 |  | BULGARIA | 0
CANADA | 1000 |  | CANADA | 1
FINLAND | 0 |  | FINLAND | 0
FRANCE | 0 |  | FRANCE | 0
ITALY | 0 |  | ITALY | 0
SLOVENIA | 0 |  | SLOVENIA | 0
SPAIN | 0 |  | SPAIN | 0
SWITZERLAND | 20000 |  | SWITZERLAND | 1
USA | 0 |  | USA | 0
OVERALL | 25400 |  | OVERALL | 7
 | 2010-01-01 00:00:00 |  |  | 2010-01-01 00:00:00
 | Finance |  |  | Correspondence
 | Winter 2009/2010 |  |  | Winter 2009/2010
 | Cheque
ANDORRA | 1000 |  | ANDORRA | 1
AUSTRIA | 0 |  | AUSTRIA | 0
BULGARIA | 0 |  | BULGARIA | 0
CANADA | 2000 |  | CANADA | 1
FINLAND | 0 |  | FINLAND | 0
FRANCE | 0 |  | FRANCE | 0
ITALY | 100 |  | ITALY | 1
SLOVENIA | 0 |  | SLOVENIA | 0
SPAIN | 0 |  | SPAIN | 0
SWITZERLAND | 0 |  | SWITZERLAND | 0
USA | 5100 |  | USA | 3
OVERALL | 8200 |  | OVERALL | 6