tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 23

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 5 | 22:00     6:00 | 23:00     7:00 |  |  |  | 22:00     6:00 | 22:00     6:00
 |  | 14:00    23:00 | 14:00    23:00 | 15:00     1:00
 |  |  | 14:00    23:00 | 22:00     6:00 | 22:00     6:00 |  | 10:00    18:00
 | 7:00     15:00 | 4:00     11:00 |  | 6:00     15:00 | 6:00     15:00
 |  | 22:00     6:00 | 22:00     6:00 |  |  | 6:00     15:00 | 7:00     17:00
 | 6:00     16:00 | 13:00    22:00 | 14:00    23:00 | 14:00    22:24
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 6 | 22:00     6:00 | 22:00     6:00 |  |  |  | 6:00     15:00 | 7:00     16:00
 | 4:00     11:00 | 5:00     13:00 | 22:00     6:00 | 23:00     7:00
 |  |  | 14:00    24:00 | 22:00     6:00 | 22:00     6:00 |  | 14:00    24:00
 | 14:00    23:00 | 22:00     6:00 | 22:00     6:00
 |  | 6:00     15:00 | 4:00     11:00 | 6:00     15:00 |  | 7:00     17:00 | 22:00     6:00
 | 22:00     6:00 |  |  | 5:00     14:00 | 6:00     15:00
Spreadsheet: 773493d1647881934-index-to-get-the-value-with-multiple-condition-vlookup-true-after-sum-of-range
Sheet: Sheet1

 | min | [NAME] |  | value |  |  | << Your formula?
 | 1 | 5 |  | 25
 | 6 | 10 |  | 35
 | 11 | 15 |  | 45
 |  | given
 | a | 2
 | b | 5
 | c | 4
 |  | correct answer ==> |  | 45 | <====  formula to get  this value
 |  |  |  |  | (given will be changed)
 |  |  |  |  | if the given value with total 8, the correct answer will be 35)
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -970 | -824
2 |  |  |  |  |  |  |  |  |  |  | -1043 | -824
3 |  |  |  |  |  |  |  |  |  |  | -872 | -824
4 |  |  |  |  |  |  |  |  |  |  | -727 | -824
5 |  |  |  |  |  |  |  |  |  |  | -670 | -824
6 |  |  |  |  |  |  |  |  |  |  | -720 | -824
7 |  |  |  |  |  |  |  |  |  |  | -648 | -824
8 |  |  |  |  |  |  |  |  |  |  | -711 | -824
9 |  |  |  |  |  |  |  |  |  |  | -466 | -824
10 |  |  |  |  |  |  |  |  |  |  | -1017 | -824
11 |  |  |  |  |  |  |  |  |  |  | -720 | -824
12 |  |  |  |  |  |  |  |  |  |  | -827 | -824
13 |  |  |  |  |  |  |  |  |  |  | -701 | -824
14 |  |  |  |  |  |  |  |  |  |  | -674 | -824
15 |  |  |  |  |  |  |  |  |  |  | -736 | -824
16 |  |  |  |  |  |  |  |  |  |  | -630 | -824
17 |  |  |  |  |  |  |  |  |  |  | -689 | -824
18 |  |  |  |  |  |  |  |  |  |  | -656 | -824
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 25186.41
2002-02-18 00:00:00
CBS Volume
 |  |  | 8555
Spreadsheet: 218170d1362384522-function-to-classify-consolidate-list-excel_example
Sheet: Sheet1

 |  |  | Input | Ouput |  |  | Reference List
 |  |  | List | Outcome |  |  | Vegetable | Fruit | Tools | Furniture
 |  |  | Orange | Fruit |  |  | Carrot | Orange | Hammer | Sofa
 |  |  | Carrot | Vegetable |  |  | Onion | Watermelon | Screwdriver
 |  |  | Watermelon | Fruit |  |  | Potato | Apple
 |  |  | Onion | Vegetable
 |  |  | Potato | Vegetable
 |  |  | Apple | Fruit
 |  |  | Hammer | Tools
 |  |  | Screwdriver | Tools
 |  |  | Sofa | Furniture
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: OandM

Operating Expenses
US $ 000s
Year
Months of Operation
Cumulative Operating Hours
O & M Costs:
Total O&M
Other!
Total Other
TOTAL OPERATING EXPS
O&M Cost/kWh w/o other
O&M Cost/kWh Total
[NAME]
Beginning Balance
[NAME]
Ending Balance
Interest Income
Cummulative Spare Turbine Payments
Property Tax
Tangible Asset Value
Rate on Machinery
[NAME]
Land Value
Rate for Real property
Property Tax
Total Property
Working Capital Requirement
Fuel
O&M
Annual increase/(release)
Spreadsheet: 701050d1603482029-drag-formula-references-skipping-rows-formula-drag-example
Sheet: List

Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Item 16
Item 17
Item 18
Item 19
Item 20
Item 21
Item 22
Item 23
Spreadsheet: 006ffbf1-05ff-4072-be08-d557a30c037c
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 3/31/2012
(As of 4/25/2012)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 3210.95
[NAME], Tomi | At-will staff for Mayor [NAME]
Ansary, Raihana | At-will staff for Mayor [NAME]
Brooks, Caryn | At-will staff for Mayor [NAME] | 250
[NAME], [NAME] | At-will staff for Mayor [NAME] | 1318.14
Clarke, [NAME] | At-will staff for Mayor [NAME]
[NAME], Todd | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 148.49
Fritz, Amanda | Commissioner
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade, [NAME] | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner
[NAME], [NAME] | At-will staff for Mayor [NAME] | 24.99
Mansoory, Atha | At-will staff for Mayor [NAME]
Marriot, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | Director of Office of Transportation
Neal, Clay | At-will staff for Mayor [NAME]
Ogden, [NAME] | At-will staff for Mayor [NAME]
Papaefthimiou, [NAME] | At-will staff for Mayor [NAME]
Parisot, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Reese, [NAME] | Director of Bureau of Police | 130
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner | 40
Sandhu, Amreet | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Stover, Chad | At-will staff for Mayor [NAME]
Thayer, Jeana | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME]
Spreadsheet: 491369d1480439596-sort-column-data-separated-by-blanks-into-other-column-data-1-
Sheet: Sheet2

15535.78925721276
198064.8972972127
238145.1279972128
241597.5663972127
66094.83504721276
10461.75170721276
986.3753342127602
25827.37135721276
147998.0027972127
180446.3212972127
182204.5456972127
40764.25719721276
6753.113511212759
384.7029232127602
45987.31017721276
181982.8965972128
203675.1420972128
184858.2322972128
37481.13417721276
5452.953102212759
138.3740922127602
3534.79600221276
191758.8364972128
235970.1554972127
235630.3574972127
48821.69509721277
7538.164856212759
327.12888921276
68874.10903721277
165711.7936972127
187652.4369972128
108775.8271972128
17545.40419721276
1781.95810521276
149956.7734972127
200229.2801972127
198247.3618972127
51995.56899721277
7053.80988321276
155.2529362127602
Spreadsheet: fletcher_sturm__10917__0518 Cash Sheet
Sheet: Sheet1

2001-05-18 00:00:00
Cinergy |  |  |  | Entergy
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-21 00:00:00 | 28 | 28.5 |  | 2001-05-21 00:00:00 | 36 | 38
May 22-31, 2001 | 36.5 | 37.5 |  | May 22-31, 2001 | 44 | 46
May 22-25, 2001 | 30 | 32 |  | May 22-25, 2001 | 38 | 39.75
 | 0 | 0 |  |  | 0 | 0
June, 2001 | 59.25 | 60.25 |  | June, 2001 | 66.25 | 67.75
July/August, 2001 | 87.25 | 90.75 |  | July/August, 2001 | 96.25 | 99.75
September, 2001 | 38 | 38.5 |  | September, 2001 | 44.25 | 44.75
Oct/Nov/Dec, 2001 | 36.25 | 36.75 |  | Oct/Nov/Dec, 2001 | 39 | 40
Jan/Feb 2002 | 40 | 41.5 |  | Jan/Feb 2002 | 41.75 | 43.25
Cal 2002 | 44.25 | 45.75 |  | Cal 2002 | 45.25 | 46.75 | 52.5
March/April , 2002 | 34.75 | 36.25 |  | March/April , 2002 | 36.5 | 38
May, 2002 | 41.5 | 43 |  | May, 2002 | 42.25 | 43.75
June, 2002 | 54 | 55.5 |  | June, 2002 | 56 | 58
July/August, 2002 | 73.25 | 75.75 |  | July/August, 2002 | 73.75 | 76.25
Sept, 2002 | 34.25 | 35.75 |  | Sept, 2002 | 35.5 | 37
Q4, 2002 | 33.5 | 35 |  | Q4, 2002 | 33.75 | 35.25
Cal 2003 | 39.25 | 41.75 |  | Cal 2003 | 39.75 | 41.25
Comed |  |  |  | TVA
 | bid | offer |  |  | bid | offer
 | 0 | 0 |  |  | 0 | 0
2001-05-21 00:00:00 | 24 | 27 |  | 2001-05-21 00:00:00 | 27 | 28.5
May 22-31, 2001 | 0 | 0 |  | May 22-31, 2001 | 36.25 | 39.75
May 22-25, 2001 | 28 | 30 |  | May 22-25, 2001 | 30 | 32
 | 0 | 0 |  |  | 0 | 0
June, 2001 | 55.25 | 56.75 |  | June, 2001 | 60 | 62
July/August, 2001 | 0 | 0 |  | July/August, 2001 | 91.75 | 95.25
September, 2001 | 35.25 | 36 | 117 | September, 2001 | 40.25 | 41
Oct/Nov/Dec, 2001 | 34 | 35 |  | Oct/Nov/Dec, 2001 | 37.5 | 38.5
Jan/Feb 2002 | 37.5 | 39 |  | Jan/Feb 2002 | 0 | 0
Cal 2002 | 42.75 | 44.25 |  | Cal 2002 | 44.25 | 45.75
March/April , 2002 | 34.25 | 35.75 |  | March/April , 2002 | 35.25 | 36.75
May, 2002 | 39.75 | 41.25 |  | May, 2002 | 41.25 | 42.75
June, 2002 | 51.25 | 52.75 |  | June, 2002 | 54.75 | 56.25
July/August, 2002 | 69 | 72.5 |  | July/August, 2002 | 0 | 0
Sept, 2002 | 34 | 35.5 |  | Sept, 2002 | 35 | 36.5
Q4, 2002 | 32.75 | 34.25 |  | Q4, 2002 | 33.75 | 35.25
Cal 2003 | 0 | 0 |  | Cal 2003 | 0 | 0
PJM
 | bid | offer
 | 0 | 0
June, 2001 | 58.75 | 59.75
July/August, 2001 | 83.5 | 87
September, 2001 | 41.25 | 42.25
Oct/Nov/Dec, 2001 | 37.5 | 38.5
Jan/Feb 2002 | 43.25 | 44
Cal 2002 | 45.25 | 46.25
March/April , 2002 | 36 | 38
May, 2002 | 40.75 | 42.25
June, 2002 | 53.25 | 55.25
July/August, 2002 | 72.25 | 74.75 | 91
Sept, 2002 | 34.75 | 36.25
Q4, 2002 | 34 | 35.5
Cal 2003 | 41.25 | 42.5
Spreadsheet: 878858d1726157340-index-match-match-2nd-instance-stuepef-index-match-match-workbook-spill-365-aligw
Sheet: TY SBCs

 | 2022 |  | 2023 |  | 2024 |  |  | Output 2nd instance
 | 1 |  | 1 |  | 1 |  | Cost per unit | 0.65
Category | Fruit |  | Fruit |  | Fruit |  | Cost per bunch | 0.15 |  | 0.15
Name | Apple |  | [NAME] |  | Apple |  | Cost per pack | 11 |  | 11
 |  |  |  |  |  |  | Pallet Cost | 58 |  | 58
Cost per unit | 0 |  | 0 |  | 0
Cost per bunch | 0 |  | 0 |  | 0
Cost per pack | 0 |  | 0 |  | 0
Pallet Cost | 0 |  | 0 |  | 0
Cost per unit | 0.5 |  | 0.55 |  | 0.65
Cost per bunch | 3 |  | 0.1 |  | 0.15
Cost per pack | 10 |  | 10.5 |  | 11
Pallet Cost | 50 |  | 55 |  | 58
Spreadsheet: 455784d1460491109-create-a-four-column-sorting-table-that-updates-based-on-calculations-16-xxx-u54-tracker-schema_safe
Sheet: StatusChart

 |  | Pending |  | Eligible |  | Enrolled |  |  | Completed
 |  | Code | Date Ready | Code | Contacted? | Code | 1st Assessment | 2nd Assessment | Code | Date | Paid?
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: July

 |  |  |  | Date | 2010-08-10 12:26:51 |  | July Total Hours
 |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 248 | 100
 | 2010 | July | 2010-07-01 00:00:00 | 0 | 16 |  |  | Total Hours Requested |  |  | 32 | 12.90322580645161
 |  |  | 2010-07-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 216 | 87.09677419354838
 |  |  | 2010-07-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2010-07-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2010-07-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2010-07-06 00:00:00 | 0
 |  |  | 2010-07-07 00:00:00 | 0
 |  |  | 2010-07-08 00:00:00 | 0
 |  |  | 2010-07-09 00:00:00 | 0
 |  |  | 2010-07-10 00:00:00 | 0
 |  |  | 2010-07-11 00:00:00 | 0
 |  |  | 2010-07-12 00:00:00 | 0
 |  |  | 2010-07-13 00:00:00 | 0
 |  |  | 2010-07-14 00:00:00 | 0
 |  |  | 2010-07-15 00:00:00 | 0
 |  |  | 2010-07-16 00:00:00 | 0
 |  |  | 2010-07-17 00:00:00 | 0
 |  |  | 2010-07-18 00:00:00 | 0
 |  |  | 2010-07-19 00:00:00 | 0
 |  |  | 2010-07-20 00:00:00 | 0
 |  |  | 2010-07-21 00:00:00 | 0
 |  |  | 2010-07-22 00:00:00 | 0
 |  |  | 2010-07-23 00:00:00 | 0
 |  |  | 2010-07-24 00:00:00 | 0
 |  |  | 2010-07-25 00:00:00 | 0
 |  |  | 2010-07-26 00:00:00 | 0
 |  |  | 2010-07-27 00:00:00 | 0
 |  |  | 2010-07-28 00:00:00 | 0
 |  |  | 2010-07-29 00:00:00 | 0
 |  |  | 2010-07-30 00:00:00 | 8
 |  |  | 2010-07-31 00:00:00 | 8
Spreadsheet: 05afc2c5-53e8-4224-8b8b-a7661a3c328e
Sheet: Sheet1

Unnamed: 0 | Hourly  Generation & Demand | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Date | 2012-04-18 01:43:03.850000
Time | Generation | Demand | Shortage | Remarks
Hour | MW | MW | MW
01:00:00 | 4218 | 4725 | 507
02:00:00 | 4255 | 4700 | 445
03:00:00 | 4254 | 4600 | 346
04:00:00 | 4243 | 4550 | 307
05:00:00 | 4225 | 4450 | 225
06:00:00 | 4192 | 4350 | 158
07:00:00 | 4084 | 4375 | 291
08:00:00 | 3716 | 4400 | 684
09:00:00 | 3770 | 4450 | 680
10:00:00 | 3786 | 4450 | 664
11:00:00 | 3817 | 4475 | 658 | Day Peak
12:00:00 | 3698 | 4500 | 802
13:00:00 | 3790 | 4450 | 660
14:00:00 | 3914 | 4450 | 536
15:00:00 | 3984 | 4500 | 516
16:00:00 | 4134 | 4480 | 346
17:00:00 | 4187 | 4450 | 263
18:00:00 | 4464 | 4800 | 336
18:30:00 | 4731 | 4800 | 69
19:00:00 | 4763 | 5000 | 237
19:30:00 | 4837 | 5000 | 163 | Evening Peak
20:00:00 | 4359 | 4500 | 141
[NAME] | 4152 | 4250 | 98
22:00:00 | 4128 | 4300 | 172
23:00:00 | 4156 | 4280 | 124
24:00 | 4211 | 4320 | 109
Spreadsheet: 123094d1317330332-populate-calendar-with-list-of-dates-excelforum-794438-calendar
Sheet: Calendar_1

 |  | 2000
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 268826d1380837673-offset-lookup-example-worksheet-1-lorber123-oeldere-
Sheet: Sheet1

Zone 1 | Zone 2 | Zone 3 | Zone 4 | Final Zone |  | [NAME]
12 | 7 | 0 | 0
7 | 7 | 0 | 0
6 | 12 | 0 | 0
6 | 12 | 0 | 0
15 | 6 | 0 | 0
15 | 6 | 0 | 0
7 | 7 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
8 | 7 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
1 | 1 | 0 | 0
6 | 1 | 1 | 0
6 | 1 | 0 | 0
6 | 1 | 0 | 0
8 | 7 | 0 | 0
6 | 1 | 0 | 0
6 | 1 | 0 | 0
12 | 7 | 0 | 0
2 | 6 | 0 | 0
2 | 12 | 0 | 0
2 | 11 | 0 | 0
2 | 6 | 0 | 0
2 | 12 | 0 | 0
2 | 12 | 0 | 0
2 | 2 | 6 | 0
2 | 6 | 0 | 0
2 | 6 | 0 | 0
12 | 7 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
1 | 6 | 0 | 0
8 | 8 | 0 | 0
8 | 8 | 0 | 0
1 | 13 | 0 | 6
1 | 13 | 6 | 0
1 | 13 | 0 | 0
8 | 8 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
13 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 13 | 6 | 0
1 | 13 | 0 | 6
1 | 13 | 6 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
1 | 6 | 0 | 0
2 | 6 | 0 | 0
2 | 14 | 0 | 0
2 | 8 | 0 | 0
Spreadsheet: 732208d1620824948-cash-flow-revenue-forecast-based-on-30-60-90-days-cashflow
Sheet: CASH FLOW

 |  |  |  | 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 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00
 |  |  | DSO
 | Revenues | Client A | 90
 | Revenues | Client B | 60 | 5000 | 15000 | 15000 | 18000 | 20000 | 36000 | 15000 | 15000 | 15000 | 18000 | 20000 | 15000 | 18000 | 20000 | 15000 | 18000 | 20000 | 15000 | 15000
 | Revenues | Client C | 30 | 75000 | 85000 | 90000 | 75000 | 15000 | 60000 | 85000 | 90000 | 85000 | 90000 | 75000 | 85000 | 90000 | 75000 | 15000 | 85000 | 90000 | 75000 | 15000
 | Cash Flow | Client A
 | Cash Flow | Client B
 | Cash Flow | Client C
 |  |  | TOTAL
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Measured | Sched | Imbal
1 | -2376 | -2100 |  | -25
2 | -2273 | -2100 |  | -25
3 | -2269 | -2100 |  | -25
4 | -2236 | -2100 |  | -25
5 | -2299 | -2100 |  | -25
6 | -2198 | -2100 |  | -25
7 | -2194 | -2100 |  | -25
8 | -2162 | -2100 | -1 | -25
9 | -2326 | -2100 |  | -25
10 | -2395 | -2100 |  | -25
11 | -2380 | -2100 |  | -25
12 | -2788 | -2100 | -9 | -25
13 | -2916 | -2100 |  | -25
14 | -3112 | -2100 |  | -25
15 | -3375 | -2100 |  | -25
16 | -3331 | -2100 |  | -25
17 | -3263 | -2100 |  | -25
18 | -3559 | -2100 |  | -25
19 | -4023 | -2100 |  | -25
20 | -3897 | -2100 |  | -25
21 | -3429 | -2100 |  | -25
22 | -3624 | -2100 |  | -25
23 | -3490 | -2100 |  | -25
24 | -3596 | -2100 |  | -21
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89767.28
2002-02-24 00:00:00
CBS Volume
 |  |  | 37041
Spreadsheet: 709219d1608212714-elegantly-reporting-duplicates-in-a-separate-sheet-popper08-elegantly-reporting-multiple-duplicates
Sheet: Sheet1

Item # | manufacturer | Duplicates formula
S123 | A Davies
S155 | B [NAME]
S177 | C Harvey
S201 | D Babb
S291 | A Davies
S302 | B Sweaver
S361 | C Harvey
S399 | A Hart
Notes
column C has this formula to highlight duplicate items   =IF(COUNTIF($B$2:$B$9,B2)>1,A2,"")
works if only one duplicate manufacturer, but not if more than one
need to report elegantly in a number of lines stating "Items S123 and S291 have the same manufacturer (A Davies)". This needs to work for up to 5 items neatlyhave the same statement if 2 or 5 occurences of the same duplicate
The wording needs to be on a separate sheet so cannot use filter etc. I need a formula
My solution treats all four items as the same duplicate manufacturer
Not pasting my "CONCAT" attempt as it is a dogs dinner
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: TrialBal

Trial Balance - 31 December, 2008
Acc. No. | Account | Debit | Credit
1-001 | National Bank - Cheque |  | 857.9100000000001
1-002 | Cash on hand
2-001 | National Bank - Visa |  | 303.36
2-002 | Provision for car maintenance |  | 15
2-501 | Loan - J Mugot |  | 3550
3-501 | Income - StudyLink |  | 552.51
3-502 | Income - other |  | 30
4-001 | Grocery | 138.25
4-002 | Genesis - Power | 105
4-003 | Petrol | 50
4-004 | Car - other | 15
4-005 | [NAME] expense
3-001 | Retained earnings | 5000.53
 | Total | 5308.78 | 5308.780000000001
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 18 Nov 19 - 23 Nov 19

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2019-11-18 00:00:00 | 2019-11-19 00:00:00 | 2019-11-20 00:00:00 | 2019-11-21 00:00:00 | 2019-11-22 00:00:00 | 2019-11-23 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 18/11/2019 - 23/11/2019
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ❌
[NAME] | Course | Course | Course | Course | N/A |  |  | 1 |  | [NAME] | Course
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | Course | Course | Course | Course | ✓ | ✓ |  | 1 |  | Tyson | Course
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Daniel - Jaydee Roofing |  |  |  |  | ✓ |  |  |  |  | Daniel - Jaydee Roofing | ❌
Sharn - Valley Art Roofing |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Edge Protection [NAME] |  |  | 18/11/2019 - 23/11/2019 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 18/11/2019 - 23/11/2019
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
35 Byron |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Move |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | N/A
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Daniel - Jaydee Roofing | ❌
 |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Spreadsheet: 771794d1646850392-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-sample-for-excel-forums
Sheet: Statistics

Total Tasks (All Projects) |  | Total Tasks (Type A) |  | Total Tasks  (Type A1) |  | Total Tasks  (Type A2) |  | Total Tasks (Type A3) |  | Total Tasks (Type B1) |  |  |  |  | Sheets
Simple |  | Simple |  | Simple |  | Simple |  | Simple |  | Simple |  |  |  |  | Client00001
Medium |  | Medium |  | Medium |  | Medium |  | Medium |  | Medium |  |  |  |  | Client00002
Complex |  | Complex |  | Complex |  | Complex |  | Complex |  | Complex |  |  |  |  | Client00003
Average Tasks (All Projects) |  | Average Tasks (Type A) |  | Average Tasks (Type A1) |  | Average Tasks (Type A2) |  | Average Tasks  (Type A3) |  | Average Tasks (Revisions) |  |  |  |  | Client00004
Simple |  | Simple |  | Simple |  | Simple |  | Simple |  | Simple
Medium |  | Medium |  | Medium |  | Medium |  | Medium |  | Medium
Complex |  | Complex |  | Complex |  | Complex |  | Complex |  | Complex
Total Scope (All Projects) |  | Total Scope (Type A) |  | Total Scope  (Type A1) |  | Total Scope  (Type A2) |  | Total Scope  (Type A3) |  | Total Scope (Type B1)
Simple Project |  | Simple Project |  | Simple Project |  | Simple Project |  | Simple Project |  | Simple Project
Medium Project |  | Medium Project |  | Medium Project |  | Medium Project |  | Medium Project |  | Medium Project
Complex Project |  | Complex Project |  | Complex Project |  | Complex Project |  | Complex Project |  | Complex Project