tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50245d1249623560-summing-building-types-to-critira-book2
Sheet: Sheet1

town 1
Type of FACILITY | NO. FACILITIES | TOTAL SQUARE METER OWNED | TOTAL SQUARE METER LEASED | TOTAL SQUARE METER | TOTAL ANNUAL RENTAL INCOME | AVERAGE RENTAL INCOME  PER SQUARE METER | TOTAL ANNUAL RENTAL EXPENDITURE | AVERAGE RENTAL EXPENDITURE PER SQUARE METER | TOTAL NO.OF FTE | AVERAGE OCCUPANCY DENSITY
Office
Lab
Work shop
Houses
Shed
Other
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
town 2
Type of FACILITY | NO. FACILITIES | TOTAL SQUARE METER OWNED | TOTAL SQUARE METER LEASED | TOTAL SQUARE METER | TOTAL ANNUAL RENTAL INCOME | AVERAGE RENTAL INCOME  PER SQUARE METER | TOTAL ANNUAL RENTAL EXPENDITURE | AVERAGE RENTAL EXPENDITURE PER SQUARE METER | TOTAL NO.OF FTE | AVERAGE OCCUPANCY DENSITY
Office
Lab
Work shop
Houses
Shed
Other
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
town 3
Type of FACILITY | NO. FACILITIES | TOTAL SQUARE METER OWNED | TOTAL SQUARE METER LEASED | TOTAL SQUARE METER | TOTAL ANNUAL RENTAL INCOME | AVERAGE RENTAL INCOME  PER SQUARE METER | TOTAL ANNUAL RENTAL EXPENDITURE | AVERAGE RENTAL EXPENDITURE PER SQUARE METER | TOTAL NO.OF FTE | AVERAGE OCCUPANCY DENSITY
Office
Lab
Work shop
Houses
Shed
Other
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 75253d1275840647-solved-auto-sum-with-date-dependency-book1
Sheet: PIVOT

Raw data
Date | Profits
2009-09-07 00:00:00 | 10 |  | Date | Profits
2009-09-07 00:00:00 | -2 |  | Jan | 32
2009-09-08 00:00:00 | 5 |  | Mar | 12
2009-09-08 12:15:27 | 1 |  | Apr | 55
2009-09-08 12:54:42 | 4 |  | May | 33
2009-09-08 12:54:42 | 7 |  | Jun | 97
2009-09-08 12:54:42 | -5 |  | Sep | 90
2009-09-09 00:00:00 | -2 |  | Oct | -20
2009-09-09 00:00:00 | -10 |  | Grand Total | 299
2009-09-09 00:00:00 | -20
2009-09-09 04:15:08 | 4
2009-09-10 08:50:17 | 12
2009-09-10 08:50:17 | 26
2009-09-10 13:39:33 | 30
2009-09-10 13:39:33 | 12
2009-09-10 13:39:33 | 44
2009-09-14 07:40:17 | 11
2009-09-14 07:40:17 | 19
2009-09-14 07:40:17 | -34
2009-09-14 09:10:08 | -55
2009-09-14 10:31:58 | -10
2009-09-15 15:27:52 | 15
2009-09-15 15:36:12 | -22
2009-09-18 00:41:32 | -1
2009-09-18 08:16:29 | 9
2009-09-24 06:20:03 | 23
2009-09-30 08:12:40 | 14
2009-09-30 14:50:13 | 5
2009-10-07 01:06:12 | 9
2009-10-08 04:23:40 | 1
2009-10-08 07:49:59 | -10
2009-10-19 14:38:00 | -20
2010-01-20 14:27:12 | 32
2010-03-31 14:47:39 | 12
2010-04-23 11:57:58 | 55
2010-05-20 00:15:59 | 41
2010-05-31 00:21:50 | -20
2010-05-31 14:37:25 | 12
2010-06-01 00:00:00 | 34
2010-06-02 10:31:31 | 32
2010-06-03 00:00:00 | 12
2010-06-03 00:00:00 | 45
2010-06-03 00:00:00 | -22
2010-06-04 00:00:00 | -16
2010-06-04 00:00:00 | 12
Spreadsheet: 645555d1571240919-spreadsheet-interest-calculation-calculator
Sheet: Balance

Date of Judgment |  |  |  | Principal |  | 0
Pre-Judgment Interest Begin |  |  |  | Pre-Judgment Interest |  | 0
Pre-Judgment Interest Rate |  |  |  | Accrued Court Costs |  | 0
Date Calculations Made |  | 2019-10-16 00:00:00 |  | Fee of Writ + Service |  | 0
Daily Interest Rate |  | 0 |  | Attorney Fee |  | 0
Post-Judgment Interest Rate |  | 0.1 |  | Post-Judgment Interest |  | 0
Date of Last Payment |  | NONE |  | Payments Made |  | 0
Amount of Last Payment |  | NONE |  | Total Due and Owing |  | 0
No. Payments Expected to Date |  | 0 |  | Daily Interest rate |  | 0.0002739726027397263
No. Actual Payments Received |  | 1 |  | Estimated Remaining Payments |  | #N/A
Arrearage |  | 0 |  | Payoff in Years |  | #N/A
Estimated Monthly Payment |  | 0 |  | Days since Judgment |  | 43754
Payment Date | Payment Amount | Payment Number | Beginning Balance | Accrued Interest | Less Payment | Ending Balance
 |  | 1 | 0
 |  |  |  | #N/A
Spreadsheet: 0296ee91-9018-4885-839e-9e1a664e1713
Sheet: HELIN FY08

HELIN Spreadsheet 2002-2003 (URI only)
Last updated: 1/16/2009 ajr
Title | Price | Type | Subscription Year | Notes
ABC-CLIO America History and Life & Historical Abstracts | 9798 | [NAME] | Fiscal | 2-6 simultaneous users
CSA ASFA | 5513 | [NAME] | Fiscal
CSA EconLit | 3397 | [NAME] | Fiscal
CSA International Pharmaceutical Abstracts | 2480 | [NAME] | Fiscal
CSA PAIS | 5400 | [NAME] | Fiscal
CSA Physical Education Index | 900 | [NAME] | Fiscal
CSA PsycINFO | 13585 | [NAME] | Fiscal
CSA Sociological Abstracts | 2864 | [NAME] | Fiscal
CQ Researcher | 1200 | [NAME] | Fiscal | 10 simul. users per site
EBSCO Academic Search Premier | 15795 | [NAME] | Fiscal
FirstSearch Base Package | 7648 | [NAME] | Fiscal | Base Package with 12 sim. users
First Search MLA International Bibliography | 4319 | [NAME] | Fiscal
Gale Literature Resource Center | 3251 | [NAME] | Fiscal
Mergent FIS online | 7685 | [NAME] | Fiscal
Music Index | 2195 | [NAME] | Fiscal
ProQuest ABI Inform | 17500 | [NAME] | Fiscal
Spreadsheet: 168003d1342185467-formula-to-select-percentage-in-numeric-format-and-for-review-book2
Sheet: Sheet1

 | Parameters | 10 | -10 | 10000 | -10000
Sum of Cumulative Balance |  |  | Year
FS DESCRIPTION | Note Dissection | NoteNo | 2012-06-30 00:00:00 | 2011-06-30 00:00:00 | Inc/Dec | % diff | Explanation Required?
Dep & Amort | Dep - Bldg and Improv | 2(d) | 10350192.26 | 10002957.21
 | Dep - Othe Prop, Plt, Eqpt | 2(d) | 1631810.39 | 1672464.16
 | Amort - Intangibles | 2(d) | 61344.18 | 61344.18
Dep & Amort Total |  |  | 12043346.83 | 11736765.55
Gain/Loss on Disposal | Proceeds from disposal | 4 | -2009.09 | -811748.24 |  |  |  | should be ok
 | Wdv of assets disposed | 4 | 81096.47 | 526809.79
 | Proceeds from disposal assets HFS | 4 | 820045.47
Gain/Loss on Disposal Total |  |  | 899132.85 | -284938.45 |  |  |  | should be ok
Gain/Loss Other | Impairment of receivables | 5 | -38389.34000000001 | 605826.95
Gain/Loss Other Total |  |  | -38389.34000000001 | 605826.95
Grants and Contributions | Other public sector agencies | 3( c) | -11837999.94 | -7640081.75
 | Commonwealth Govt | 3( c) | -2100
 | Donations and [NAME] | 3( c) | -33975 | -12570.05
Grants and Contributions Total |  |  | -11874074.94 | -7652651.8
Investment revenue | Interest Revenue | 3(b) |  | -2949.5
Investment revenue Total |  |  |  | -2949.5
Spreadsheet: 199189d1355139332-how-to-link-2-columns-from-one-sheet-to-another-example12
Sheet: Hoja2

 |  | Link these numbers to sheet 1
 |  | 237733 |  | 45.5
 |  | 36633 |  | 29.611
 |  | 35566 |  | 28.749
 |  | 34531 |  | 27.911
 |  | 33525 |  | 27.098
 |  | 32548 |  | 26.309
 |  | 31600 |  | 25.543
 |  | 30680 |  | 24.799
 |  | 29786 |  | 24.076
 |  | 28612 |  | 11.113
Spreadsheet: e3bcc62f-aa2f-463b-a991-840feecb1f8f
Sheet: JUNE

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-06-01 00:00:00 | TO | 2015-06-30 00:00:00 |  | MO. NO.: |  | 6
Holiday Pay |  |  |  | HP
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 88 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 14 |  | 15 |  | 16 | Time sheets due | 17 |  | 18 |  | 19 |  | 20
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27
 |  |  | 4 |  | 4
 | 28 |  | 29 | Pay day | 30
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 491017d1480265359-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-7-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | Stacy
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARINGS (Week End Total):
Spreadsheet: 07112f6b-fd63-4540-ad11-0d0ff364b96c
Sheet: Sheet1

TAYLOR POLICE DEPARTMENT RACIAL PROFILING DATA | 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
2006
Traffic Citations |  | pct. |  |  |  |  |  |  |  |  |  | pct | of cites no DL
 | 2006
African American | 550 | 0.1156190876602901
Hispanic | 1450 | 0.3048139583771284
White, non-Hispanic | 2704 | 0.5684254782425898
Other | 53 | 0.01114147571999159
total | 4757
Arrest Totals
(number is derived from total number of charges) | 2006
African American | 264 | 0.2621648460774578
Hispanic | 433 | 0.4299900695134062
White, non-Hispanic | 301 | 0.2989076464746773
Other | 9 | 0.00893743793445879
total | 1007
Vehicle Searches 2006 |  | pct. | consent | probable cause
African American | 7 | 0.2333333333333333 | 7
Hispanic | 9 | 0.3 | 9
White, non-Hispanic | 14 | 0.4666666666666667 | 14
Other
total | 30 |  | 30 | 0
Arrests from Traffic 2006 |  | pct.
(number is derived from total number of charges)
African American | 63 | 0.2368421052631579
Hispanic | 121 | 0.4548872180451128
White, non-Hispanic | 82 | 0.3082706766917293
Other |  | 0
total | 266
Spreadsheet: 674130d1587671321-assistance-with-vlookup-function-book1
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2
Employee | 2020-04-03 00:00:00 | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 |  | Employee | Date | Hours
Number 1 |  |  |  |  | Number 1 | 2020-04-03 00:00:00 | 4.5
Number 2 |  |  |  |  | Number 2 | 2020-04-17 00:00:00 | 0.5
Number 3 |  |  |  |  | Number 2 | 2020-04-10 00:00:00 | 1.5
Number 4 |  |  |  |  | Number 2 | 2020-04-03 00:00:00 | 1.25
Number 5 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 2
Number 6 |  |  |  |  | Number 3 | 2020-04-03 00:00:00 | 25
Number 7 |  |  |  |  | Number 4 | 2020-04-03 00:00:00 | 2
Number 8 |  |  |  |  | Number 4 | 2020-04-10 00:00:00 | 4
Number 9 |  |  |  |  | Number 5 | 2020-04-03 00:00:00 | 8
Number 10 |  |  |  |  | Number 5 | 2020-04-10 00:00:00 | 5
 |  |  |  |  | Number 6 | 2020-04-17 00:00:00 | 5.5
 |  |  |  |  | Number 7 | 2020-04-03 00:00:00 | 8
 |  |  |  |  | Number 7 | 2020-04-10 00:00:00 | 4
 |  |  |  |  | Number 8 | 2020-04-03 00:00:00 | 1
 |  |  |  |  | Number 9 | 2020-04-03 00:00:00 | 2
 |  |  |  |  | Number 9 | 2020-04-17 00:00:00 | 2
 |  |  |  |  | Number 10 | 2020-04-03 00:00:00 | 0.5
 |  |  |  |  | Number 10 | 2020-04-17 00:00:00 | 0.25
Spreadsheet: 774370d1648434026-transpor-lines-columns-comb-brjohnsmith-
Sheet: Planilha1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
A | 1 | 4 | 9 | 10 | 15 |  |  |  | a | 1
B | 30 | 34 | 38 | 39 | 50 |  |  |  | a | 4
C | 102 | 110 | 122 | 134 | 160 |  |  |  | a | 9
D | 201 | 270 | 291 | 320 | 336 |  |  |  | a | 10
E | 420 | 428 | 456 | 488 | 521 |  |  |  | a | 15
 |  |  |  |  |  |  |  |  | b | 30
 |  |  |  |  |  |  |  |  | b | 34
 |  |  |  |  |  |  |  |  | b | 38
 |  |  |  |  |  |  |  |  | b | 39
 |  |  |  |  |  |  |  |  | b | 50
 |  |  |  |  |  |  |  |  | c | 102
 |  |  |  |  |  |  |  |  | c | 110
 |  |  |  |  |  |  |  |  | c | 122
 |  |  |  |  |  |  |  |  | c | 134
 |  |  |  |  |  |  |  |  | c | 160
 |  |  |  |  |  |  |  |  | d | 201
 |  |  |  |  |  |  |  |  | d | 270
 |  |  |  |  |  |  |  |  | d | 291
 |  |  |  |  |  |  |  |  | d | 320
 |  |  |  |  |  |  |  |  | d | 336
 |  |  |  |  |  |  |  |  | e | 420
 |  |  |  |  |  |  |  |  | e | 428
 |  |  |  |  |  |  |  |  | e | 456
 |  |  |  |  |  |  |  |  | e | 488
 |  |  |  |  |  |  |  |  | e | 521
Spreadsheet: 551544d1513006115-solved-help-with-sorting-and-deleting-data-book1-1-
Sheet: Sheet1

Global Company Key | Data Date | Company Name | Price May
17185 | 20131231 | 22ND CENTURY GROUP INC | 0.59
17185 | 20141231 | 22ND CENTURY GROUP INC | 14.96
17185 | 20151231 | 22ND CENTURY GROUP INC | 18
137136 | 20071231 | 24/7 KID DOC INC | 22.7
137136 | 20081231 | 24/7 KID DOC INC | 0.15
137136 | 20101231 | 24/7 KID DOC INC | 161.18
19881 | 20141231 | 2U INC | 14.44
19881 | 20151231 | 2U INC | 16.84
19881 | 20161231 | 2U INC | 16.35
14898 | 20061231 | 3D SYSTEMS CORP | 19.8
14898 | 20101231 | 3D SYSTEMS CORP | 0.36
14898 | 20121231 | 3D SYSTEMS CORP | 30.4
14898 | 20131231 | 3D SYSTEMS CORP | 48.52
Spreadsheet: 487841d1478272923-auto-populate-weekdays-and-dates-in-the-specific-cells-workbook
Sheet: Sheet1

2016-10-01 00:00:00
Monthly Report
Total Buses |  |  |  | Total Spare Buses |  |  | Total Buses |  | Work Days Current Month
 |  |  |  |  |  |  |  |  | 22
Date | WeekDay | Heading Sample |  |  |  |  | # | # | total | #
 |  | A | B | C | D | Total
##
####
Spreadsheet: 61204d1262024194-salary-planner-help-excel-forum-salary-planner
Sheet: Sheet1

Years | Hourly Wage | Weekly | Annual
 |  | 40 | 52 |  | 0.3684210526315789
1 | 19.55 | 782 | 40664
2 | 19.91842105263158 | 796.7368421052631 | 41430.31578947368
3 | 20.28684210526316 | 811.4736842105264 | 42196.63157894737
4 | 20.65526315789474 | 826.2105263157895 | 42962.94736842105 |  | http://www.excelforum.com/excel-general/712059-salary-planner-help.html
5 | 21.02368421052632 | 840.9473684210526 | 43729.26315789473
6 | 21.39210526315789 | 855.6842105263158 | 44495.57894736843
7 | 21.76052631578947 | 870.421052631579 | 45261.89473684211
8 | 22.12894736842105 | 885.1578947368421 | 46028.21052631579
9 | 22.49736842105263 | 899.8947368421052 | 46794.52631578947
10 | 22.86578947368421 | 914.6315789473683 | 47560.84210526315
11 | 23.23421052631579 | 929.3684210526316 | 48327.15789473684
12 | 23.60263157894737 | 944.1052631578947 | 49093.47368421053
13 | 23.97105263157895 | 958.8421052631578 | 49859.78947368421
14 | 24.33947368421052 | 973.578947368421 | 50626.10526315789
15 | 24.7078947368421 | 988.3157894736842 | 51392.42105263157
16 | 25.07631578947368 | 1003.052631578947 | 52158.73684210526
17 | 25.44473684210526 | 1017.78947368421 | 52925.05263157894
18 | 25.81315789473684 | 1032.526315789474 | 53691.36842105263
19 | 26.18157894736842 | 1047.263157894737 | 54457.68421052631
20 | 26.55 | 1062 | 55224
Spreadsheet: 135343d1325959589-from-a-filtered-list-need-to-get-avg-of-values-from-data-on-2-other-columns-qtyprice-avg
Sheet: Sheet1

Invoice | Descrition | Quantity | Price | Discount | Total | Type |  | Qty p/ Inv | Total p/ Inv
15640 | ker-Bain satin 1 shamp 250ml | 1 | 35 | 0 | 35 | P |  | 1 | 35
14471 | Shampoo volume expand 250ml | 2 | 17 | 0 | 34 | P
14471 | Spray volume expand 125ml | 1 | 19 | 0 | 19 | P
14471 | TA-fix anti-frizz 400ml | 1 | 21 | 0 | 21 | P |  | 4 | 74
14471 | XX fer FHI | 1 | 125 | 0 | 125 | S
15204 | lait tendresse nature kids 150ml | 1 | 14.75 | 0.3 | 10.32 | P
15204 | shamp nature tendresse kids 500ml | 2 | 17.25 | 0.3 | 24.15 | P
15204 | SU- paddle brosse | 1 | 75 | 0.3 | 52.5 | P |  | 4 | 86.97
15337 | [NAME] repair 200ml | 4 | 28.1 | 0 | 112.4 | P |  | 4 | 112.4
15856 | SU- ample angora 150ml | 1 | 40 | 0 | 40 | P |  | 1 | 40
17091 | Pureology hydrate shampoo 300ml | 2 | 30 | 0 | 60 | P |  | 2 | 60
16340 | ker-bain mirroir 2 shamp [NAME] | 1 | 35 | 0 | 35 | P
16340 | ker-serum nuit 125ml | 3 | 54 | 0 | 162 | P |  | 4 | 197
15196 | Meches papier | 1 | 120 | 0 | 120 | S
15640 | Coloration | 1 | 55 | 0 | 55 | S
15640 | ker-Bain satin 1 shamp 250ml | 1 | 35 | 0 | 35 | P |  | 1 | 35
15919 | Mise en plis | 1 | 35 | 0 | 35 | S
14726 | Mise en plis | 1 | 40 | 0 | 40 | S
8 unique invoices |  |  |  |  |  | Type P
 |  |  |  |  |  |  |  | Avg Qty p/Inv | [NAME]
Spreadsheet: 9bd56e5e-8ff9-486a-a09e-a8024c450088
Sheet: Sheet1

Unnamed: 0 | Title | Author | Publisher | Country | ISBN | Bib. [NAME] | Price | Publication Year | [NAME]
 | Economy of Brunei Darussalam : Modeling & Policy Stimulation | [NAME] | [NAME], Brunei | Brunei | 9991707875 | 181p. | 20 | 2011 | 1.	Brunei Darussalam  Economic Conditions 2.	[NAME]  Social Conditions
 | [NAME] and Handling of Meat |  | State Mufti's Office, Prime Minister's Office, [NAME] | Brunei | 9991733922 | Xix, 311p. | 25 | 2011
Spreadsheet: 813124d1673561829-countif-between-two-dates-countif-between-two-dates
Sheet: Taux de service

 | Taux de service
2022
2023
2024
2025 | Mois | 2
2026 | Année | 2023
2027
2028 |  |  | 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
 |  | Service
 |  | Logistique
 |  | Ressource Humaines
 |  | Finnance et Comptabilité
 |  | Commercial
 |  | Marketing
 |  | IT
 |  | Service | Employés | Date de départ | Date de retour | Type de congés | durée | Total | Depuis Recrutement | Reliquat
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  | Ressource Humaines | [NAME] | 2023-01-11 00:00:00 | 2023-01-23 00:00:00 | CA | 12 |  | 161.8333333333333
 |  | Ressource Humaines | Bekka Souad | 2022-12-20 00:00:00 | 2023-01-10 00:00:00 | CA | 21 |  | 161.9166666666667
 |  | Ressource Humaines | [NAME] sabria | 2023-02-12 00:00:00 | 2023-03-02 00:00:00 | CA | 18 |  | 238.5833333333333
Spreadsheet: 817136d1676015525-stock-allocation-tool-need-formula-with-2-conditions-cartel1
Sheet: Foglio1

 | MIN | 1
 | MAX | 3
 |  |  | 18 | 31 | 5 | 39 | 33 | 4 | 15 | 52
 |  | ALLOCATION KEY | BOLLITORE ELETTRICO 1,7 LT | 6 BICCHIERI ACQUA BORMIOLI | COMPLETO LETTO SINGOLO M.ITALY | TOVAGLIA 100% COTONE 140X230CM | TOVAGLIA ANTIMACCHIA 140X180 | LENZUOLO CON ANGOLI 180X200CM | LENZUOLO CON ANGOLI 90X200 CM | SET 18 PEZZI PIATTI VETRO B.CO
 | TOT | Priority | 73020 | 1733 | 15043 | 35075 | 45015 | 45031 | 75031 | 3056
808 | LI-COLLESALVETTI | 99
807 | LI-ROSIGNANO MARITTIMO | 98
817 | [NAME] COREGLIA | 97
803 | FI-FUCECCHIO | 96
822 | PI-LARI | 95
809 | LI-VIA LULLI | 94
813 | LU-MASSAROSA | 93
823 | PI-FRAZ.PUTIGNANO | 92
814 | LU-PIETRASANTA | 91
812 | LU-ALTOPASCIO | 90
821 | PI-MONTESCUDAIO | 89
819 | MS-MONTIGNOSO | 88
815 | LU-PORCARI | 87
811 | LI-VIA DI COLLINAIA | 86
820 | MS-AVENZA | 85
810 | LI-VIA MASTACCHI | 84
818 | LU-PIEVE FOSCIANA | 83
816 | LU-VIAREGGIO | 82
Spreadsheet: 141240d1329164085-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist2
Sheet: Running

Event & Age Category (use dropdown list) | Team Name (if applicable) | Level of Play | First Name | Last Name | Concatenate | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade | Tenpin Average | Bowling Centre | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes
 |  |  | Test1 | Test1 | Test1 Test1 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test2 | Test2 | Test2 Test2 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test3 | Test3 | Test3 Test3 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test4 | Test4 | Test4 Test4 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test5 | Test5 | Test5 Test5 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test6 | Test6 | Test6 Test6 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test8 | Test8 | Test8 Test8 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test9 | Test9 | Test9 Test9 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test10 | Test10 | Test10 Test10 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test11 | Test11 | Test11 Test11 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test12 | Test12 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test13 | Test13 | Test13 Test13 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test14 | Test14 | Test14 Test14 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test15 | Test15 | Test15 Test15 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test16 | Test16 | Test16 Test16 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test17 | Test17 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test18 | Test18 | Test18 Test18 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test19 | Test19 | Test19 Test19 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test20 | Test20 | Test20 Test20 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test21 | Test21 | Test21 Test21 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test22 | Test22 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test23 | Test23 | Test23 Test23 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test24 | Test24 | Test24 Test24 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 84880d1284984556-breaking-down-revenues-test
Sheet: Sheet1

 | Scenario A
 | Revenues | Expenses
2010-01-01 00:00:00 | 45000 |  | When the 45000 revenue is input in [NAME], it should start breaking down the revenue in Column C based on $10000/day.
2010-01-02 00:00:00 |  | 10000
2010-01-03 00:00:00 |  | 10000
2010-01-04 00:00:00 |  | 10000
2010-01-05 00:00:00 |  | 5000
2010-01-06 00:00:00
2010-01-07 00:00:00 | 38000 | 10000
2010-01-08 00:00:00 |  | 10000
2010-01-09 00:00:00 |  | 10000
2010-01-10 00:00:00 |  | 8000
 | Scenario B
 | Revenues | Expenses
2010-01-01 00:00:00 | 45000 | 3000 | Here at the end of the day, I manually input the actual expenditure of $3000 on the 1st of Jan. the formula should automatically recalculate the remaining amount and allocate it to further days.
2010-01-02 00:00:00 |  | 10000
2010-01-03 00:00:00 |  | 10000
2010-01-04 00:00:00 |  | 10000
2010-01-05 00:00:00 |  | 10000
2010-01-06 00:00:00 |  | 2000
2010-01-07 00:00:00 | 38000 | 10000
2010-01-08 00:00:00 |  | 10000
2010-01-09 00:00:00 |  | 10000
2010-01-10 00:00:00 |  | 8000
2010-01-11 00:00:00