tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  | -12545 | -12020
2 | -10540 | -10000 | -48006 | -47537
3 | -11307 | -10000 | -48201 | -47537
4 | -10040 | -10000 | -47983 | -47537 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  | Cumulative
5 | -10313 | -10000 | -25316 | -25163 |  |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Balance
6 | -10601 | -10000 | -109993 | -109606 |  |  |  |  | 2000-12-01 00:00:00 | Balance as of 12/31/00 |  |  |  |  | -7752
7 |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -231248 | -57416 | -97420 | -261633
8 |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -21620 | -15000 | 0 | -5000
9 |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -162976 | 0 | -266 | -160000
10 |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | -796190 | -10000 | -33222 | -771924
11 |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -893146 | -43184 | 0 | -842284
12 |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | -652748 | -31034 | -332106 | -946401
13 |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -1299468 | -656709 | -734846 | -1410580
14 |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | -1826791 | -534941 | -305444 | -1560630
15 |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | -1552478 | -728692 | -117048 | -943957
16 |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | -1139380 | -196498 | -307336 | -1322794
17 |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 | -144119 | -155994 | -1349971 | -1325152
18 |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 | -379245 | -376245 | -721032 | -724604
19 |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | -279779 | -271068 | -1831943 | -1808648 |  |  | estimated
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 41682
2002-02-06 00:00:00
CBS $
 |  |  | 51949.24
Spreadsheet: 67559d1268152230-scheduling-720959-tourney
Sheet: Sheet1

 |  | Divisional Games |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Div
 | Round | Game 1 |  | Game 2 |  | Game 3 |  | Game 4 |  | Game 5 |  | Game 6 |  | Game 7 |  | Game 8 |  | Game 9 |  | Game 10 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 1 | 2 | 5 | 3 | 4 | 7 | 10 | 8 | 9 | 12 | 15 | 13 | 14 | 17 | 20 | 18 | 19 | 1 | 6 | 11 | 16 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 2 | 1 | 5 | 2 | 3 | 6 | 10 | 7 | 8 | 11 | 15 | 12 | 13 | 16 | 20 | 17 | 18 | 4 | 9 | 14 | 19 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 3 | 1 | 4 | 5 | 3 | 6 | 9 | 10 | 8 | 11 | 14 | 15 | 13 | 16 | 19 | 20 | 18 | 2 | 7 | 12 | 17 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 4 | 1 | 3 | 4 | 2 | 6 | 8 | 9 | 7 | 11 | 13 | 14 | 12 | 16 | 18 | 19 | 17 | 5 | 10 | 15 | 20 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 5 | 1 | 2 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 12 | 14 | 15 | 16 | 17 | 19 | 20 | 3 | 8 | 13 | 18 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 6 | 2 | 5 | 3 | 4 | 7 | 10 | 8 | 9 | 12 | 15 | 13 | 14 | 17 | 20 | 18 | 19 | 1 | 16 | 11 | 6 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 7 | 1 | 5 | 2 | 3 | 6 | 10 | 7 | 8 | 11 | 15 | 12 | 13 | 16 | 20 | 17 | 18 | 4 | 19 | 14 | 9 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 8 | 1 | 4 | 5 | 3 | 6 | 9 | 10 | 8 | 11 | 14 | 15 | 13 | 16 | 19 | 20 | 18 | 2 | 17 | 12 | 7 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 9 | 1 | 3 | 4 | 2 | 6 | 8 | 9 | 7 | 11 | 13 | 14 | 12 | 16 | 18 | 19 | 17 | 5 | 20 | 15 | 10 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 10 | 1 | 2 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 12 | 14 | 15 | 16 | 17 | 19 | 20 | 3 | 18 | 13 | 8 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 876965d1723663262-find-a-specific-text-for-each-day-with-a-hyperlink-hyperlinks
Sheet: Plan1

Date | Value 1 | Value 2 |  | Obs:
01/08/2024 | -161757.38 | 161757.38 | 0
02/08/2024 | -114660.51 | 114660.51 | 0
05/08/2024 | -360862.72 | 359470.72 | -1392.000000000058
06/08/2024 | -34529 | 34529 | 0
07/08/2024 | -666121 | 666121.0000000001 | 0
08/08/2024 | -387346.42 | 387346.42 | 0
09/08/2024 | -149895.95 | 149526.35 | -369.6000000000058
12/08/2024 | -877737.9800000001 | 877735.9100000003 | -2.069999999832362
13/08/2024 | -73300.59 | 73300.59000000001 | 0
O erro está em 1 dos 2 ao lado
Incluir E-CPF Alessandro na planilha (Aguardando se encaminharam NF ou se faremos como Mov.Bancário)
[NAME]
RH verificando dif. De 0,27 ¢
Spreadsheet: 807884d1670132033-formular-for-analyze-best-and-weak-students-g666-ver-3006-ans4
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | sd\
Spreadsheet: 823806d1680144383-reconfiguring-columns-in-a-table-s666-pq-reconfiguring-columns-in-a-table
Sheet: Result

Segments | CY22 Actuals | CY23  Budget (Original) | CY23  Budget (Revised) | YTD Budget (Original) | YTD Budget (Revised) | YTD Actuals | YTD Actuals vs YTD Budget (Original) | YTD Actuals vs YTD Budget (Revised) | Left to Spend (Budget (Revised)-YTD Actuals)
1 | 28444.27000000001 | -289165 | 65449 | -351114 | 3500 | 2648 | 353762 | -852 | 62801
21
22 | 537911.1399999998 | 729256 | 729256 |  |  | 31259.54 |  |  | 697996.46
23 | 6102.82 | 113470 | 113470 |  |  | 53.9 |  |  | 113416.1
24 | 4671.25 | 4905 | 4905
25 | 98237.95000000003 | 131845 | 131845 |  |  | 871.6999999999999 |  |  | 130973.3
26 | 135452.77 | 154236 | 154236 |  |  | 165.65 |  |  | 154070.35
27 | 199915.73 | 202322 | 202322 |  |  | 828.37 |  |  | 201493.63
28 | 6258.280000000001 | 63000 | 63000
29 | 988549.9399999998 | 1399034 | 1399034 | 0 | 0 | 33179.16 | 33179.16 | 33179.16 | 1365854.84
4 | 13011.2 |  |  |  |  | 6215.570000000001
5 | 24422.75 |  |  |  |  | 8298.78
6 | 0 |  |  |  |  | 74471.36000000003
7 | 1053503.36 |  |  |  |  | 124812.87
Total
Spreadsheet: 702922d1604609081-dynamic-drop-down-list-data-validation-issue-for-multi-rowed-table-dynamicdropdown-forumsafe-
Sheet: O Locations

Office Name | Associated Region
A - 1 | 1
B - 1 | 1
C - 1 | 1
D - 2 | 2
E - 2 | 2
F - 2 | 2
G - 3 | 3
H - 3 | 3
I - 4 | 4
J - 4 | 4
K - 4 | 4
L - 5 | 5
M - 5 | 5
N - 7 | 7
O - 9 | 9
Spreadsheet: 190c3a21-e308-4030-bacf-799720f75e51
Sheet: Sheet1

FINISH LINE INC /IN/ | Unnamed: 1
SC 13G
[NAME]
Information Statement Pursuant to Rules 13d-1 and 13d-2
1 | NAME OF REPORTING PERSON
 | S.S. OR I.R.S. IDENTIFICATION NO. OF ABOVE
 | PERSON
 | Citadel Advisors LLC
2 | CHECK THE APPROPRIATE BOX IF A MEMBER OF
 | A GROUP
 | (a) [_]
 | (b) [_]
3 | SEC USE ONLY
4 | CITIZENSHIP OR PLACE OF ORGANIZATION
 | Delaware
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 87470d1287365116-sales-forecasting-formula-eg1
Sheet: Sheet1

 | SALES |  |  |  |  |  |  |  |  |  |  |  | FORECAST
Item | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00
A | 0 | 0 | 0 | 0 | 120 | 0 | 0 | 120 | 0 | 60 | 192 | 0
B | 24 | 84 | 180 | 48 | 120 | 144 | 120 | 48 | 324 | 120 | 24 | 0
C | 288 | 264 | 24 | 408 | 432 | 0 | 216 | 240 | 72 | 120 | 504 | 360
D | 312 | 528 | 24 | 528 | 504 | 0 | 264 | 168 | 192 | 120 | 576 | 360
Spreadsheet: 112174d1308305510-area-sorting-from-a-given-list-challanging-test-file
Sheet: Sheet1

ADDRESS | Area
[NAME] Wakf Advisry Committee Medehlly Road Chitradurga 577501 Karnataka State | Chitradurga | I found it manually but is should come with a formula
Gopala V S/O Venkateshappa Hirekarapanahalli (V) Magondi (P) Bangarpet (Tq) Kolar (D) Pin 563114 | Kolar
Money Pathak S/O Shri Krishn [NAME], Address-Babu Ram Market, Budaun (U.P.) Pincode-243601 | Budaun
[NAME]. Villege And Post- [NAME] . [NAME]. Dis-Parbhani. Pin-431514.
Name- Atish [NAME].[NAME] Asok [NAME] ,Mukund Nagar,C/Ward,[NAME],Mumbai-400017.
Bhupender Kumar S/O Achhar Singh Vill.Baag P/O Meshran Teh.Sarkaghat Distt.[NAME] (Hp) | bowli / mandi | if in field there are two areas which match then
[NAME] Hno-7 [NAME] 2Nd Main,Nagarabavi Road,Banglore Phno-[PHONE]
Anjan K Baruah, E -204,Vaibhav Park, Opp-Domino'S Pizza,Mira -Bhayander Road, Mira Road(E),Thane
Hari Narayan Ran South Railway Colony Buxar Qutter Number 5Ab Post Gahadharganj Dixt [NAME]
Rathan Vaishnav Sri Maruti Medical Opp:-Pattamlamma Temple Jigani Anekal Main Road Bangalore:-83
[NAME]/O Ramchander V.P.O-Dehra Teh.Samalkha (132122) Distt-Panipat ([NAME])
Name - Bijay Kr. [NAME] No 2 Post - Malkera Dist - Dhanbad Pin - 828304 (Jharkhand)
Mynamearti Myaddresssanjay S Jogioutsiteseprat Gateoppdolarhotle [NAME] Pin3700001
Vishwas Kumar S/O Ramdhan Town-Nakur Moh.-Choudhriyan Post [NAME]. [NAME]
Name:[NAME] Sir Name: Sawnur Adress:[NAME] Galli Staion [NAME]: [NAME] No:551
[NAME] Faroqiya [NAME] Konch Road Orai Jila Jalone
Chandan S\O Narsingh Chanwariya Add- Shiv Bari Ramdave Mandir K Pass Ward No. 40 Bikaner Rajsthan
D.Mohammed Malik 28Musthafa Kamaal Street Karaikal 609602 Puthuchery State             [PHONE]
Name Mrityunjai Kumar Tiwari Village.Husenpur Post.Nawanagar Districs.Ballia {U.P.}Mo.87561 02220
[NAME], Opp;Mdo Office, [NAME], Kuderu(Po)Ananthapur(Dist)A.P. [NAME]
D.V.A Narerh. S/O: D. Satyanarayana. D/No: 61-6-43. Venkannapalem. [NAME]. 530011.
M.Venkateswarlu,Do.No:-37-7-26 ,[NAME] ,Opp 5Th Town Police Station,Visakhapatnam-530007....
Vishwas Kumar S/O Ramdhan Town-Nakur Moh.-Choudhriyan Post [NAME]. [NAME]
[NAME] (U.K) Pin N 248197
[NAME],Radio Mantra [NAME],Prime Tower Near Raddison Hotel,Bmc Chowk.Jalandhar City.
[NAME]. At-[NAME] Pin-415011 Maharastra.
Nitesh Pandey C/O Sudheer Chandra 2/66 Endralok Haidil Calony Krishna Nager Lucknaw Utter Pradesh
Dayachand/Dayachands%Rambir,V.P.O -Goria,Dist-Jhajjar,Tech-Matenhail,State-Haryana,Pin No.-124142
Ajith Kotian S/O Appu Salian Madikettu House Moodubelle Post Udupi Tq & Dist Karnataka Pin_576120
Karamchati Hymavathi Mangalipallam [NAME] Tenali [NAME] [NAME]
Name- Promit Dhar C/O- [NAME] P.O- Muniadihi Dist- Mushidabad Pin-742161
[NAME]. 47, Opp Siraj Fair Price Depot, 1St Cross, [NAME], Tumkur-572101, Karnataka
Mujeeb Pasha No 8,1St Floor Opp F,M Times Shop Someshwaranagar Jayanagr 1St Block Banglore:560011
M.P.Rao,H-No-34,Path Number-7,Vijay Badi,Near Shyam Baba Mandhir,[NAME],Jaipur.[NAME].
Name_Prashant [NAME] Address_At Post.[NAME] (Harasul) Tel.[NAME].Nashik
Name: Dattatraya Dagadu Bhoite Addres:At Sangavi [NAME]:[NAME]:[NAME]
Spreadsheet: 150411d1334511906-struggling-to-move-and-link-data-without-access-book1
Sheet: Sheet2

Name | Age | Hair | Weight | ever seen UFO | where | How big
Spreadsheet: 140270d1328672646-how-to-remove-text-from-a-cell-everything-before-a-comma-book1
Sheet: Sheet2

 | RTC | RPM | TPS | CL Comp | Target AFR | AFR Average | [NAME] | AFR Right | MAP | [NAME] | Fuel Flow | VSS | Oil Pressure | Knock Retard | Ignition Timing | Fuel Pressure
Spreadsheet: 91504d1291221567-excel-2007-excel-formula-comparing-2-sheets-excel-sheet-help
Sheet: % Complete

 | DH Coordinator
REGION 1
Bay | 1
[NAME]
Escambia
Gulf
[NAME]
[NAME]
Okaloosa
Santa Rosa
[NAME]
Washington
Percent Complete
REGION 2
Columbia | 1
Dixie
Franklin
[NAME]
[NAME]
[NAME]
Lafayette
[NAME]
Liberty
[NAME]
[NAME]
[NAME]
Wakulla
Percent Complete
REGION 3
Alachua
[NAME]
Bradford
Clay
Duval
Flagler
Gilchrist
[NAME]
Marion
Nassau
Putnam
[NAME]
Union
Percent Complete
REGION 4
Citrus
Hardee
Hernando
Hillsborough
Pasco
Pinellas
Polk
Sumter
Percent Complete
REGION 5
Brevard
Indian River
Lake
Martin
Orange
Osceola
Seminole
St Lucie
Volusia
Percent Complete
REGION 6
Charlotte
Collier
DeSoto
Glades
Hendry
Highlands
[NAME]
Manatee
Okeechobee
Sarasota
[NAME]
Percent Complete
REGION 7
Broward
Miami-Dade
Monroe
Palm Beach
Percent Complete
Progress
Spreadsheet: 272006d1382128626-date-year-only-function-date-and-age_1
Sheet: Sheet1

D.O.B
1985-02-12 00:00:00 | 28.6986301369863 | 28
1954-04-12 00:00:00 | 59.55890410958904 | 59
1987-12-04 00:00:00 | 25.89041095890411 | 25
1987-12-08 00:00:00 | 25.87945205479452 | 25
2011-06-29 00:00:00 | 2.306849315068493 | 2
1937-12-12 00:00:00 | 75.9013698630137 | 75
 | 113.8767123287671
 | 113.8767123287671
 | 113.8767123287671
 | 113.8767123287671
 | 113.8767123287671
 | 113.8767123287671
 | 113.8767123287671
Spreadsheet: rick_buy__32847__Sum 10-17 E11
Sheet: Interp

9/8 | 10/9 |  | survive |  | 9/8 | 10/9 |  | survive |  | 9/8 | 10/9 |  | survive
Spreadsheet: 870966d1717435147-sumproduct-doesnt-work-in-table-but-works-in-standard-spreadsheet-classeur2
Sheet: Feuil1

 | 0 | 0
Address | Town | Region | Expense type | Year | Amount | Reference |  |  | Colonne1 | 2024 | 2025 | 2026
Address 1 | Town 1 | Whatever | Whatever | 2024 | 459095 | P2742 |  |  | Address 1
Address 1 | Town 1 | Whatever | Tax | 2024 | 3500 |  |  |  | Address 2
Address 1 | Town 1 | Whatever | Whatever | 2025 | 167583 | P1421 |  |  | Address 3
Address 1 | Town 1 | Whatever | Whatever | 2026 | 340677 | P4862 |  |  | Address 4
Address 1 | Town 1 | Whatever | Sale |  | -338401 | P2382 |  |  | Address 5
Address 2 | Town 2 | Whatever | Whatever | 2024 | 146007 | P2679 |  |  | Address 6
Address 2 | Town 2 | Whatever | Whatever | 2025 | 366081 | [NAME] |  |  | Address 7
Address 2 | Town 2 | Whatever | Whatever | 2026 | 439946 | P1726 |  |  | Address 8
Address 2 | Town 2 | Whatever | Sale |  | -86778 | [NAME]
Address 3 | Town 3 | Whatever | Whatever | 2024 | 122297 | P2607
Address 3 | Town 3 | Whatever | Whatever | 2025 | 84138 | P4580 |  |  |  | 2024 | 2025 | 2026
Address 3 | Town 3 | Whatever | Whatever | 2026 | 64322 | P3300 |  |  | Address 1
Address 3 | Town 3 | Whatever | Sale |  | -446199 | P3747 |  |  | Address 2
Address 4 | Town 1 | Whatever | Whatever | 2024 | 95207 | P4333 |  |  | Address 3
Address 4 | Town 1 | Whatever | Tax | 2024 | 10000 |  |  |  | Address 4
Address 4 | Town 1 | Whatever | Whatever | 2025 | 217041 | P2013 |  |  | Address 5
Address 4 | Town 1 | Whatever | Whatever | 2026 | 457148 | P964 |  |  | Address 6
Address 4 | Town 1 | Whatever | Sale |  | -225837 | P4337 |  |  | Address 7
Address 5 | Town 3 | Whatever | Whatever | 2024 | 316556 | P1105 |  |  | Address 8
Address 5 | Town 3 | Whatever | Whatever | 2025 | 474477 | P332
Address 5 | Town 3 | Whatever | Whatever | 2026 | 218914 | P2977
Address 5 | Town 3 | Whatever | Sale |  | -202554 | P182
Address 6 | Town 1 | Whatever | Whatever | 2024 | 207620 | P256
Address 6 | Town 1 | Whatever | Tax | 2024 | 5000
Address 6 | Town 1 | Whatever | Whatever | 2025 | 314950 | P811
Address 6 | Town 1 | Whatever | Whatever | 2026 | 160249 | P3598
Address 6 | Town 1 | Whatever | Sale |  | -404048 | P3766
Address 7 | Town 2 | Whatever | Whatever | 2024 | 282040 | P3350
Address 7 | Town 2 | Whatever | Whatever | 2025 | 206390 | P3593
Address 7 | Town 2 | Whatever | Whatever | 2026 | 482979 | P4678
Address 7 | Town 2 | Whatever | Sale |  | -79493 | P269
Address 8 | Town 4 | Whatever | Whatever | 2024 | 378671 | P2392
Address 8 | Town 4 | Whatever | Whatever | 2025 | 152678 | P2983
Address 8 | Town 4 | Whatever | Whatever | 2026 | 382411 | P3692
Address 8 | Town 4 | Whatever | Sale |  | -65772 | P2608
Spreadsheet: 856399d1705655235-arranging-client-highest-to-lowest-sample-with-pivot-table
Sheet: Summary

Real Estate and Projects
 | 2024 |  |  |  | 2023 |  |  |  | 2022 |  |  |  | 2021
Margin % - Summary
 | 2024 |  |  |  | 2023 |  |  |  | 2022 |  |  |  | 2021
Client Group | Fees (£) | Cost (£) | MP % |  | Fees (£) | Cost (£) | Growth % | MP % | Fees (£) | Cost (£) | Growth % | MP % | Fees (£) | Cost (£) | MP %
Total
Spreadsheet: 686162d1594394451-array-formula-across-multiple-worksheets-and-columns-per-diem-test
Sheet: Sample CONUS rates

FY2020 Per Diem Rates - Effective October 1, 2019
STATE | DESTINATION | SEASON BEGIN | SEASON END | FY20 Lodging Rate | FY20 M&IE
 | Standard CONUS rate applies to all counties not specifically listed. Cities not listed may be located in a listed county. |  |  | 96 | 55
AL | Birmingham | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 110 | 56
AL | Gulf Shores | 2019-10-01 00:00:00 | 2020-02-29 00:00:00 | 112 | 61
AL | Gulf Shores | 2020-03-01 00:00:00 | 2020-05-31 00:00:00 | 130 | 61
AL | Gulf Shores | 2020-06-01 00:00:00 | 2020-07-31 00:00:00 | 169 | 61
AL | Gulf Shores | 2020-08-01 00:00:00 | 2020-09-30 00:00:00 | 112 | 61
AL | Mobile | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 96 | 61
AL | Mobile | 2020-01-01 00:00:00 | 2020-02-29 00:00:00 | 104 | 61
AL | Mobile | 2020-03-01 00:00:00 | 2020-09-30 00:00:00 | 96 | 61
AR | Hot Springs | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 104 | 61
AZ | Grand Canyon / Flagstaff | 2019-10-01 00:00:00 | 2019-10-31 00:00:00 | 141 | 66
AZ | Grand Canyon / Flagstaff | 2019-11-01 00:00:00 | 2020-02-29 00:00:00 | 96 | 66
AZ | Grand Canyon / Flagstaff | 2020-03-01 00:00:00 | 2020-04-30 00:00:00 | 115 | 66
AZ | Grand Canyon / Flagstaff | 2020-05-01 00:00:00 | 2020-09-30 00:00:00 | 141 | 66
AZ | Kayenta | 2019-10-01 00:00:00 | 2019-10-31 00:00:00 | 130 | 66
AZ | Kayenta | 2019-11-01 00:00:00 | 2019-12-31 00:00:00 | 108 | 66
AZ | Kayenta | 2020-01-01 00:00:00 | 2020-09-30 00:00:00 | 130 | 66
AZ | Phoenix / Scottsdale | 2019-10-01 00:00:00 | 2020-05-31 00:00:00 | 146 | 56
AZ | Phoenix / Scottsdale | 2020-06-01 00:00:00 | 2020-08-31 00:00:00 | 96 | 56
AZ | Phoenix / Scottsdale | 2020-09-01 00:00:00 | 2020-09-30 00:00:00 | 146 | 56
Spreadsheet: 747552d1631570355-deferred-revenue-calculation-deferred-revenue
Sheet: Sheet1

Invoice Date | Start Date | End Date | Amount | Monthly Value | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00
2020-09-01 00:00:00 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 | 65000
2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00 | 65000
the below figure is required
2020-09-01 00:00:00 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 | 65000 |  | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67
2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00 | 65000 |  | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67 | 5416.67
correct (??) distribution of amount
2020-09-01 00:00:00 | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 | 65000
2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00 | 65000
Spreadsheet: 754864d1636548481-randomly-assign-cell-values-by-date-1
Sheet: Sheet1

 | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | Number of tasks for each client
Client 1 | x |  | x |  |  |  | x
Client 2 | x | x |  |  | x
Client 3 | x |  |  | x |  | x | x
Client 4 |  |  |  | x | x
Client 5 |  | x | x |  |  | x
Client 6 |  |  | x |  | x |  | x
Client 7 | x | x | x | x | x | x | x
Client 8 |  |  |  | x
Client 9 |  | x |  |  |  | x
All tasks
Spreadsheet: 860033d1708265347-formula-to-check-overlapping-dates-by-another-column-formula-to-check-overlapping-dates-by-another-column-hd
Sheet: Sheet1 (2)

ITEM | QUANTITY | INSTALL DATE | PICK UP DATE | PACKAGE | NO. WEEKS | Availaility |  |  | Workings: | First Occurance Dates |  | Availaility | Combined Formula
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-08 00:00:00 | 2023-10-03 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-21 00:00:00 | 2023-10-16 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-03 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-28 00:00:00 | 2023-10-09 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2024-01-09 00:00:00 | 2024-02-13 00:00:00 | DESIGNER | 5 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-17 00:00:00 | 2023-09-11 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-08-29 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-09-12 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-11 00:00:00 | 2023-10-06 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-17 00:00:00 | 2023-09-28 00:00:00 | Essential | 6 |  | <-- should show as "Available" because the date is after 11/9
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-17 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-25 00:00:00 | 2023-11-06 00:00:00 | Essential | 6
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-26 00:00:00 | 2023-11-07 00:00:00 | Essential | 6 |  | <-- what happens when the item is avail, so now it is taken (row above) and this row should be Check
[NAME] to check overlapping dates by another column
[NAME] to check overlapping dates by another column - Reply to Topic (excelforum.com)
Spreadsheet: 758541d1638934178-how-to-get-dates-whose-number-of-consecutive-days-must-be-greater-than-or-equal-to-5-days-12-07-1-
Sheet: Sheet1

Date |  |  |  |  | Date
2021-12-01 00:00:00
2021-12-02 00:00:00
2021-12-03 00:00:00
2021-12-06 00:00:00
2021-12-07 00:00:00
2021-12-08 00:00:00
2021-12-09 00:00:00
2021-12-10 00:00:00
2021-12-12 00:00:00
2021-12-13 00:00:00
2021-12-18 00:00:00
2021-12-19 00:00:00
2021-12-22 00:00:00
2021-12-23 00:00:00
2021-12-26 00:00:00
2021-12-28 00:00:00
2021-12-29 00:00:00
2021-12-30 00:00:00
2021-12-31 00:00:00
Spreadsheet: 870611d1717086031-different-rows-sum-up-depending-on-a-dropdown-menu-example
Sheet: Tabelle2

 | [NAME] | January | February | March | Mai | June | July | September | Oktober |  |  | Sum
 | Blue | 2000 |  | 4000 | 333 | 0 |  | 999 | 333 |  | Blue | Sum of Row 6,8,12,15
 | [NAME] | 22 | 333333 | 55000 | 2222 | 55500 | 60004 | 3000 | 5000 |  | [NAME] | Sum of Row 7, 10,14
 | Blue | 20000 | 2000 | 2200 | 20000 |  | 5000 | 30000 | 5000 |  | Red | same as above
 | Yellow | 20300 |  |  |  |  | 60 |  |  |  | Yellow | same as above
 | [NAME] | 2000 | 499 | 5000 |  | 400000 | 200 |  |  |  | Orange | same as above
 | Orange | 50000 |  |  |  |  |  | 4440000
 | Blue | 6000 |  | 50
 | Orange | 8000 | 5000 |  |  | 490 |  | 4000
 | [NAME] | 2000 |  | 30 | 20000 | 2000 | 40500 |  | 4000
 | Blue | 670 |  | 6000 |  |  | 3002 |  | 400000