tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 697812d1601553650-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics-pq
Sheet: Data

Date | Credit | Debit | Amount | Project |  |  |  | Credit | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk
2018-11-17 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-03-15 00:00:00 | [NAME] | Ellen | 280 | Proj-6
2017-04-10 00:00:00 | Adam | [NAME] | 150 | Proj-8
2018-12-07 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 320 | Proj-5
2019-08-15 00:00:00 | Ellen | Emily | 700 | Proj-8
2019-04-20 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2020-04-30 00:00:00 | Adam | [NAME] | 200 | Proj-3
2019-02-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2019-01-09 00:00:00 | [NAME] | Ellen | 1700 | Proj-2
2018-08-26 00:00:00 | [NAME] | Adam | 500 | Proj-5 |  |  |  | Debit | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk
2017-04-10 00:00:00 | Adam | [NAME] | 180 | Proj-8
2019-11-28 00:00:00 | Ellen | [NAME] | 400 | Proj-9
2018-08-02 00:00:00 | Emma | Adam | 920 | Proj-10
2017-06-04 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-11-23 00:00:00 | Ellen | Adam | 1500 | Proj-6
2017-06-02 00:00:00 | Adam | [NAME] | 280 | Proj-1
2018-09-27 00:00:00 | [NAME] | Adam | 1170 | Proj-5
2018-04-15 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
2020-04-22 00:00:00 | Adam | [NAME] | 400 | Proj-3
2018-07-12 00:00:00 | [NAME] | Adam | 495 | Proj-5
2019-11-13 00:00:00 | Emily | [NAME] | 650 | Proj-9 |  |  |  | Balance | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk
2019-08-19 00:00:00 | Ellen | [NAME] | 500 | Proj-8
2018-04-15 00:00:00 | [NAME] | Adam | 500 | Proj-5
2017-06-10 00:00:00 | Adam | [NAME] | 1000 | Proj-5
2019-08-19 00:00:00 | Ellen | Emily | 300 | Proj-8
2018-02-09 00:00:00 | [NAME] | Ellen | 400 | Proj-6
2019-02-05 00:00:00 | Emma | Ellen | 3400 | Proj-7
2018-08-12 00:00:00 | Ellen | Adam | 500 | Proj-6
2018-07-12 00:00:00 | Adam | [NAME] | 350 | Proj-5
2018-11-07 00:00:00 | Adam | Emily | 185 | Proj-6 |  |  | Balance
2019-11-20 00:00:00 | Adam | [NAME] | 300 | Proj-9
2019-03-15 00:00:00 | [NAME] | Emily | 360 | Proj-6
2018-08-04 00:00:00 | [NAME] | Emily | 250 | Proj-1
2018-08-15 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2020-04-26 00:00:00 | Adam | [NAME] | 250 | Proj-3
2019-11-20 00:00:00 | Adam | [NAME] | 450 | Proj-9
2018-07-09 00:00:00 | [NAME] | [NAME] | 350 | Proj-5
2018-10-05 00:00:00 | Emma | Adam | 550 | Proj-5
2019-11-25 00:00:00 | Ellen | [NAME] | 300 | Proj-9
2019-11-24 00:00:00 | [NAME] | Emily | 650 | Proj-4
2017-04-10 00:00:00 | Adam | [NAME] | 105 | Proj-10
2017-07-10 00:00:00 | Adam | [NAME] | 2000 | Proj-5
2018-10-31 00:00:00 | [NAME] | Adam | 1500 | Proj-5
2019-11-05 00:00:00 | Ellen | [NAME] | 400 | Proj-3
2018-02-13 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2018-04-24 00:00:00 | [NAME] | Adam | 495 | Proj-5
2018-04-11 00:00:00 | [NAME] | Adam | 1000 | Proj-5
2019-12-23 00:00:00 | Ellen | [NAME] | 150 | Proj-1
2018-06-28 00:00:00 | [NAME] | [NAME] | 1000 | Proj-5
Spreadsheet: mike_grigsby__27925__HS_WESTminusPA
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NATURAL GAS BASIS POSITIONS
 | 2001-10-23 00:00:00
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 86353d1286358314-excel-2008-solved-column-chart-conditional-formatting-748236
Sheet: Sheet1

Select company: | A
 |  |  | Data | Highlight
A | 1700 | D | 1750
B | 1600 | A | 1700
C | 1500 | B | 1600
D | 1400 | C | 1500
 |  |  |  |  | The third column was coloured orange before the data was sorted and as you can see it is the position that retains the formatting. I'd like, in this example for the C column to always be coloured not matter where it appears on the x-axis.
Spreadsheet: 466010d1465982343-number-is-in-vertical-format-book1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | Answer
 | 2995 | 2890 | 2985 | 2990 | 2930 | 2970 |  |  | 2995
 | 2930 | 0 | 2990 | 2960 | 2980 | 1135 |  |  | 2930
 | 2985 | 0 | 1870 | 2995 | 2955 | 0 |  |  | 2985
 | 2890 | 0 | 0 | 1015 | 2935 | 0 |  |  | 2890
 | 0 | 0 | 0 | 0 | 2970 | 0 |  |  | 2890
 | 0 | 0 | 0 | 0 | 2910 | 0 |  |  | 2985
 | 0 | 0 | 0 | 0 | 2980 | 0 |  |  | 2990
 | 0 | 0 | 0 | 0 | 165 | 0 |  |  | 1870
 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2990
 |  |  |  |  |  |  |  |  | 2960
 |  |  |  |  |  |  |  |  | 2995
 |  |  |  |  |  |  |  |  | 1015
 |  |  |  |  |  |  |  |  | 2930
 |  |  |  |  |  |  |  |  | 2980
 |  |  |  |  |  |  |  |  | 2955
 |  |  |  |  |  |  |  |  | 2935
 |  |  |  |  |  |  |  |  | 2970
 |  |  |  |  |  |  |  |  | 2910
 |  |  |  |  |  |  |  |  | 2980
 |  |  |  |  |  |  |  |  | 165
 |  |  |  |  |  |  |  |  | 2970
 |  |  |  |  |  |  |  |  | 1135
Spreadsheet: 84253d1284286582-calculate-working-days-sample
Sheet: Sheet1

Staff id | Staff name | Basic | Overtime | Allowance | Total Salary | Join Date | Provision calculation date | Total working  Days | Gratuity Prvn
1 | a | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
2 | b | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
3 | c | 600 |  | 600 |  | 2005-08-21 00:00:00 | 31/07/2010
4 | d | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
5 | e | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
6 | f | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
7 | g | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
8 | h | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
9 | i | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
10 | j | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
11 | k | 600 |  | 600 |  | 2007-09-01 00:00:00 | 31/07/2010
12 | l | 600 |  | 600 |  | 2007-12-08 00:00:00 | 31/07/2010
13 | m | 600 |  | 600 |  | 2007-12-08 00:00:00 | 31/07/2010
14 | n | 600 |  | 600 |  | 2007-12-08 00:00:00 | 31/07/2010
15 | o | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
16 | p | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
17 | q | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
18 | r | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
19 | s | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
20 | t | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
21 | u | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
22 | v | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
23 | w | 600 |  | 600 |  | 2007-07-29 00:00:00 | 31/07/2010
24 | x | 600 |  | 600 |  | 2007-08-21 00:00:00 | 31/07/2010
25 | y | 600 |  | 600 |  | 2007-09-01 00:00:00 | 31/07/2010
26 | z | 600 |  | 600 |  | 2007-12-08 00:00:00 | 31/07/2010
Spreadsheet: 114692d1310418265-pivot-table-subtotal-of-subtotals-subtotal-20subtotals-20pivot-20table-1-
Sheet: Sheet2

Sum of Payment Amount |  | Name
Company Paid | Date Paid | [NAME] | [NAME] | [NAME] | Grand Total
Electric Company | 2011-01-01 00:00:00 | 60 | 50 |  | 110
 | 2011-02-01 00:00:00 | 5 | 26 |  | 31
 | 2011-02-04 00:00:00 |  |  | 15 | 15
 | 2011-03-01 00:00:00 | 65 | 28 | 25 | 118
 | 2011-04-01 00:00:00 | 125 | 30 | 65 | 220
 | 2011-05-01 00:00:00 |  | 32 |  | 32
Electric Company Total |  | 255 | 166 | 105 | 526
Gas Company | 2011-01-11 00:00:00 | 20 |  |  | 20
 | 2011-02-11 00:00:00 | 45 |  |  | 45
 | 2011-03-11 00:00:00 | 105 |  |  | 105
Gas Company Total |  | 170 |  |  | 170
Water Company | 2011-01-04 00:00:00 |  |  | 55 | 55
 | 2011-01-06 00:00:00 |  | 25 |  | 25
 | 2011-01-07 00:00:00 |  |  | 35 | 35
 | 2011-01-09 00:00:00 | 25 |  |  | 25
 | 2011-02-06 00:00:00 |  | 27 |  | 27
 | 2011-02-07 00:00:00 |  |  | 5 | 5
 | 2011-02-09 00:00:00 | 25 |  |  | 25
 | 2011-03-06 00:00:00 |  | 29 |  | 29
 | 2011-03-07 00:00:00 |  |  | 45 | 45
 | 2011-03-09 00:00:00 | 85 |  |  | 85
 | 2011-04-06 00:00:00 |  | 31 |  | 31
 | 2011-04-09 00:00:00 | 145 |  |  | 145
Water Company Total |  | 280 | 112 | 140 | 532
Grand Total |  | 705 | 278 | 245 | 1228
Spreadsheet: darrell_schoolcraft__7703__August 2002 Maint
Sheet: Sheet1

AUGUST 2002
2002-03-06 00:00:00
SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  | 1 | 2 | 3
4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  | Navajo ESD
 |  |  | 280 MMcf/d
11 | 12 | 13 | 14 | 15 | 16 | 17
Navajo 2C Hot Gas Path
230 MMcf/d
 | Seligman Turbine Tie-Ins
18 | 19 | 20 | 21 | 22 | 23 | 24
 | Flagstaff Engine Maint
 | 80 MMcf/d
 |  |  |  | Laguna ESD
25 | 26 | 27 | 28 | 29 | 30 | 31
Flagstaff Engine Maint
80 MMcf/d
Spreadsheet: 101574d1299681215-conditional-formatting-formulas-book1_smart_as
Sheet: Sheet1

2011-03-01 00:00:00 | 2011-03-02 00:00:00 | 2011-03-03 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | 2011-03-06 00:00:00 | 2011-03-07 00:00:00
2011-03-08 00:00:00 | 2011-03-09 00:00:00 | 2011-03-10 00:00:00 | 2011-03-11 00:00:00 | 2011-03-12 00:00:00 | 2011-03-13 00:00:00 | 2011-03-14 00:00:00
2011-03-15 00:00:00 | 2011-03-16 00:00:00 | 2011-03-17 00:00:00 | 2011-03-18 00:00:00 | 2011-03-19 00:00:00 | 2011-03-20 00:00:00 | 2011-03-21 00:00:00
2011-03-22 00:00:00 | 2011-03-23 00:00:00 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 2011-03-26 00:00:00 | 2011-03-27 00:00:00 | 2011-03-28 00:00:00
2011-03-29 00:00:00 | 2011-03-30 00:00:00 | 2011-03-31 00:00:00 | 2011-04-01 00:00:00 | 2011-04-02 00:00:00 | 2011-04-03 00:00:00 | 2011-04-04 00:00:00
Spreadsheet: 3174109f-fb5b-4f88-8f86-01467e9923f5
Sheet: Cover

PROCUREMENT & SOURCING SERVICES
To: | Long Island University |  |  | CAMPUS: |  |  |  | APPLICATION NO.:
 | 700 Northern Blvd. |  |  | BUILDING:
 | Brookville, NY 11548 |  |  | PROJECT: |  |  | PERIOD TO:
From: |  |  |  | LIU PROJECT # |  |  |  | CONTRACT DATE:
 |  |  |  |  |  |  | The undersigned Contractor certifies that to the best of the Contractor's knowledge, information and belief the Work covered by this Application for Payment has been completed in accordance with the Contract Documents, that all amounts have been paid the  Contractor for the Work for which previous Certificates for Payment were issued and payments received from LIU and that current payment shown herein is now due.
ORIGINAL CONTRACT SUM
NET CHANGE BY CHANGE ORDERS
CONTRACT SUM TO DATE
TOTAL COMPLETED & STORED TO DATE
RETAINAGE
TOTAL EARNED LESS RETAINAGE
LESS PREVIOUS CERTIFICATES FOR PAYMENTS |  |  |  |  |  | Signed:
CURRENT PAYMENT DUE |  |  |  |  |  | Date:
BALANCE TO FINISH PLUS RETAINAGE |  |  |  |  |  |  | In accordancw with the Contract Documents, based on on-site observations and the data comprising the application, the Architect certifies to the Owner that to the best of the Architect's knowledge, information and belief the Work has progressed as indicated, the quality of the Wrok is in accordance with the Cotnract Dcouments and the Contractor is entitled to payment of the CURRENT PAYMENT DUE.
CHANGE ORDER SUMMARY
Total Approved in Previous Months
Total Approved this Month
Total Change Orders to Date
LIU APPROVALS
Project Manager |  |  |  | Date |  | Signed:
Facilities Director |  |  |  | Date
CFS or Controller's Office |  |  |  | Date |  | Date
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 126122d1319537978-if-statement-help-io-cargo-tracker
Sheet: Historical IO Cargoes

 | [NAME]
 | Origin | Grade | Type | Quantity (tons) | Port of Discharge | Date of Shipment | Date of Arrival | Vessel Name | Vessel Type | Purchase Price (FOB) | Freight Cost | Price Sold (CFR) | Profit | Buyer | Date Sold | End-User
 | Fomento (1) | 52/52 | Fines | 65000 | DBT | 2011-10-11 00:00:00 | 2011-11-24 00:00:00 | DBT | Panamax | 74 | 19 | 96 |  | General Nice | 2011-10-14 00:00:00 | -
 | Kandla | 70/68 | [NAME] | 30000 | DBT | DBT | DBT | DBT | DBT | DBT | DBT | 166 |  | Min Metals | 2011-10-10 00:00:00 | DBT
 | Fomento (3) | 53/52 | Fines | 70000 | DBT | 2011-11-10 00:00:00 | DBT | DBT | Capesize | 54 | 16 | 86 |  | [NAME] | 2011-10-24 00:00:00 | DBT
 | Formento (2) | 52/52 | Fines | 70000 | DBT | 2011-11-11 00:00:00 | DBT | DBT | Capesize | 74 | 16 | 86 |  | [NAME] | 2011-10-25 00:00:00 | DBT
 | Profit/Losses
Spreadsheet: 66640d1267270296-linking-data-to-different-tabs-in-excel-staff-5
Sheet: employee 1

employee 1
task | date
Spreadsheet: 162788d1340064796-balance-rows-and-columns-balance-rows-and-columns
Sheet: Sheet1

The Result I am looking for:
 |  | M1 | M2 | M3 | M4 | M5 | TOTAL |  |  |  | M1 | M2 | M3 | M4 | M5 | TOTAL
[NAME] |  | 0 | 650 | 200 | 300 | 260 |  |  | [NAME] |  | 0 | 1200 | 1300 | 1475 | 920
Item1 | 125 | 0 | 58 | 18 | 26 | 23 |  |  | Item1 | 90 | 0 | 22 | 24 | 27 | 17
Item2 | 10 | 0 | 5 | 1 | 2 | 2 |  |  | Item2 | 1250 | 0 | 306 | 332 | 377 | 235
Item3 | 125 | 0 | 58 | 18 | 26 | 23 |  |  | Item3 | 500 | 0 | 123 | 132 | 151 | 94
Item4 | 100 | 0 | 46 | 14 | 22 | 18 |  |  | Item4 | 1350 | 0 | 331 | 359 | 407 | 253
Item5 | 150 | 0 | 69 | 21 | 32 | 28 |  |  | Item5 | 200 | 0 | 49 | 53 | 60 | 38
Item6 | 400 | 0 | 184 | 57 | 85 | 74 |  |  | Item6 | 300 | 0 | 74 | 80 | 90 | 56
Item7 | 300 | 0 | 138 | 43 | 64 | 55 |  |  | Item7 | 10 | 0 | 2 | 3 | 3 | 2
Item8 | 200 | 0 | 92 | 28 | 43 | 37 |  |  | Item8 | 675 | 0 | 166 | 179 | 203 | 127
 |  |  |  |  |  |  |  |  | Item9 | 160 | 0 | 39 | 42 | 49 | 30
 |  |  |  |  |  |  |  |  | Item10 | 360 | 0 | 88 | 96 | 108 | 68
 | Data I have (variable number of rows/columns
 | [NAME] I need (must be whole numbers - no fractions)
 | Totals need to match the row/column data I have
The [NAME] I tried:
 |  | M1 | M2 | M3 | M4 | M5 | TOTAL |  |  |  | M1 | M2 | M3 | M4 | M5 | TOTAL
[NAME] |  | 0 | 650 | 200 | 300 | 260 |  |  | [NAME] |  | 0 | 1200 | 1300 | 1475 | 920
Item1 | 125 |  |  |  |  |  |  |  | Item1 | 90
Item2 | 10 |  |  |  |  |  |  |  | Item2 | 1250
Item3 | 125 |  |  |  |  |  |  |  | Item3 | 500
Item4 | 100 |  |  |  |  |  |  |  | Item4 | 1350
Item5 | 150 |  |  |  |  |  |  |  | Item5 | 200
Item6 | 400 |  |  |  |  |  |  |  | Item6 | 300
Item7 | 300 |  |  |  |  |  |  |  | Item7 | 10
Item8 | 200 |  |  |  |  |  |  |  | Item8 | 675
 |  |  |  |  |  |  |  |  | Item9 | 160
 |  |  |  |  |  |  |  |  | Item10 | 360
 | Cells in RED indicate differences between manual and formula
Spreadsheet: 1dae497f-b05c-453a-81b1-9a6c58603361
Sheet: 1

 |  | Aanmeldformulier cursus W-official
 |  | District 5, Zeeland / Noord-Brabant / Limburg
 |  | Vereniging(en): |  |  |  |  |  |  | Locatie:
 |  | Contactpersoon: |  |  |  |  |  |  | Adres:
 |  | Telefoon: |  |  |  |  |  |  | Plaats:
 |  | E-mail: |  |  |  |  |  |  | Cursusleider:
 |  |  | E-mail 2: |  |  |  |  |  | Telefoon:
 |  |  |  |  |  |  |  |  | E-mail:
 |  | [NAME] |  |  | Datum |  |  |  | Aanvang |  | [NAME] is verplicht.
 |  | Bijeenkomst 1: |  |  |  |  |  |  |  |  | Stuur dit formulier uiterlijk twee weken voor [NAME] aan: [EMAIL].
 |  | Bijeenkomst 2:
 |  | Bijeenkomst 3:
 |  | Examen:
 |  |  | Voornaam |  |  |  | Achternaam |  | Geb.datum |  | M/V |  | LT |  | Vereniging
 |  | 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
 |  | Opmerkingen of aanvullende afspraken
Spreadsheet: 147519d1332837520-count-if-formula-ex
Sheet: February

 | 2012 | Febuary
 |  | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-11 00:00:00 | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00
 | Accounts
 | Rod | y | w | w | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | H | H | W | W | y | y | y | y | y | W | W | y | y | y |  |  |  |  | Y | Present
 | [NAME] | y | w | w | y | y | y | y | y | W | W | y | y | y | y | a | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y
 | [NAME] | y | w | w | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y |  |  |  |  | W | Weekend
 | Zippiy | y | w | w | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | s | s | H | W | W | y | y | y |  |  |  |  | S | Sick Day
 | George | 0 | w | w | 0 | 0 |  |  |  | W | W |  |  |  |  |  | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y |  |  |  |  | S.5 | Half day sick
 |  | 0 | w | w | 0 | 0 |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  |  |  | H | Holiday Full Day
 |  | 0 | w | w | 0 | 0 |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  |  |  | H.5 | Holiday Half Day
 |  | 0 | w | w | 0 | 0 |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  |  |  | A | Absent Day
 |  | 0 | w | w | 0 | 0 |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  |  |  | B | Bank Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √ | Time Recorded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not worked (part time)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | Lieu day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NM | No more off
Spreadsheet: 794962d1662442134-make-an-average-based-on-the-data-that-contain-number-0-make-an-average-based-on-the-last-data-contain-number-aligw
Sheet: FIND SUMMARY

 |  | NO | DATE | Feed |  |  |  |  |  |  | RESULT
 |  |  |  | Morning | Night | TOTAL
 |  | 1 | 2022-09-01 00:00:00 | 0 | 0 |  |  |  |  | LAST FEED |  |  | THIS IS THE FORMULA THAT DEVINE THE LAST DATA > 0
 |  | 2 | 2022-09-02 00:00:00 | 30 | 0
 |  | 3 | 2022-09-03 00:00:00 | 30 | 30 |  |  |  |  | LAST 5 DAYS |  |  | THIS IS THE AVERAGE I WANT FROM THE LAST FEED
 |  | 4 | 2022-09-04 00:00:00 | 150 | 120
 |  | 5 | 2022-09-05 00:00:00 | 90 | 70 |  |  |  |  | LAST 10 DAYS |  |  | I WANT TO MAKE BOTH AUTOMATICALLY AVERAGING FEED FROM THE PAST 5 OR 10 DAYS SINCE THE LAST DATE THAT CONTAIN NUMBER
 |  | 6 | 2022-09-06 00:00:00 | 120 | 100
 |  | 7 | 2022-09-07 00:00:00 | 120 | 120
 |  | 8 | 2022-09-08 00:00:00 | 150 | 30
 |  | 9 | 2022-09-09 00:00:00 | 150 | 30
 |  | 10 | 2022-09-10 00:00:00 | 150 | 30
 |  | 11 | 2022-09-11 00:00:00 | 150 | 30
 |  | 12 | 2022-09-12 00:00:00 | 150 | 30
 |  | 13 | 2022-09-13 00:00:00 | 150 | 30
 |  | 14 | 2022-09-14 00:00:00 | 0 | 0
 |  | 15 | 2022-09-15 00:00:00 | 0 | 0
Spreadsheet: 125682d1319158368-sumif-on-multiple-sheets-mar-2010
Sheet: Mar 2010

Render | Charge Amount | Payments | wRVUs
Physician 5 | 42658 |  | 0.61
Physician 5 | 57754 |  | 0.15
Physician 5 | 147944 |  | 0.04999999999999999
Physician 5 | 3914 |  | 6.1
Physician 5 | 81656 |  | 5.699999999999999
Physician 5 | 81956 |  | 0.7000000000000001
Physician 5 | -775 |  | 5.399999999999999
Physician 5 | -1486 |  | 4.8
Physician 5 | 2477 |  | 2.1
Physician 1 | 4914 |  | 2.7
Physician 2 | -1491 |  | 7
Physician 3 | 6397 |  | 0.18
Physician 1 | 96245 |  | 8.29
Spreadsheet: 184137-list-data-from-cells-in-a-single-table-row-into-a-multi-column-and-multi-row-range-example-for-asaan
Sheet: Sheet that needs autofill Skip

 | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1
 | Table Header 1 | Table Header 2 | Table Header 3 |  | Table Header 4 | Table Header 5 | Table Header 6 |  | Table Header 7 | Table Header 8 | Table Header 9
 | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1
 | Table Header 10 | Table Header 11 | Table Header 12 |  | Table Header 13 | Table Header 14 | Table Header 15 |  | Table Header 16 | Table Header 17 | Table Header 18
 | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1 |  | Table Header 1 Row 1 | Table Header 1 Row 1 | Table Header 1 Row 1
 | Table Header 4 | Table Header 5 | Table Header 6 |  | Table Header 4 | Table Header 5 | Table Header 6 |  | Table Header 4 | Table Header 5 | Table Header 6
 | Data 3 Aa | Data 3 Ab | Data 3 Ac |  | Data 3 Ea | Data 3 Eb | Data 3 Ec |  | Data 3 Ia | Data 3 Ib | Data 3 Ic
 | Data 3 Ba | Data 3 Bb | Data 3 Bc |  | Data 3 Fa | Data 3 Fb | Data 3 Fc |  | Data 3 Ja | Data 3 Jb | Data 3 Jc
 | Data 3 Ca | Data 3 Cb | Data 3 Cc |  | Data 3 Ga | Data 3 Gb | Data 3 Gc |  | Data 3 Ka | Data 3 Kb | Data 3 Kc
 | Data 3 Da | Data 3 Db | Data 3 Dc |  | Data 3 Ha | Data 3 Hb | Data 3 Hc |  | Data 3 La | Data 3 [NAME] | Data 3 Lc
etc… | etc…. | etc…. | etc…. |  | etc…. | etc…. | etc…. |  | etc…. | etc…. | etc….
 | I need the data in the Red Boxes to have a formula that when you drag the AutoFill it will return the data as it is portrayed.
 | I already have a formula, thatnks to user simarui, for the column with the "Name #" entries and tried to play around with it for the other columns I need on this page; however I have been unsuccessful at every turn with all the ideas I have tried to impliment.