tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775745d1649283631-creating-an-automated-cash-flow-example-cost-schedule-bvj-
Sheet: Sheet1

Costs |  |  |  |  | % spread | effective date | Delivery Phase II | 30% ABC | Training
 |  |  |  |  | AA | 0.2 | 0.35 | 0.35 | 0.1
Activity | Cost | [NAME] |  |  | ABS | 0.2 | 0.35 | 0.35 | 0.1
AA |  | See spread
ABS |  | See spread
ADM | 30000 | KOM
ACI | 35000 | PFD review Meeting
AFC | 30000 | P&ID Review meeting
AFD | 47000 | PDP review Meeting
AGMA | 15000 | 30% Model review
AISC | 30000 | 60% Model review
ANSI | 87500 | 90% Model review
APHA |  | OGS
API | 60000 | HAZOP review meeting
ASCE |  | 30% ABC
ASD |  | 60% ABC
ASME |  | 90% ABC
ASTM |  | Training
AWS |  | Commission
BFW |  | PTR
BOD | 0 | Document Review
Total
 |  | KOM | Effective date | Delivery Phase I | PFD Review Meeting | Delivery Phase II | Delivery Phase III | P&ID review meeting | Delivery Phase IV | PDP review Meeting | 30% Model review | 60% Model review | 30% ABC | HAZOP review meeting | 90% Model review | OGS | 60% ABC | 90% ABC | Training | Mechanical completion | Commission | Start-up | PTR | TOTAL
 | 0 |  |  |  |  |  |  |  |  | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(K$24,$G$1:$J$1,0)),0) | =IFERROR(INDEX(Cost,[NAME]) | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(M$24,$G$1:$J$1,0)),0) | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(N$24,$G$1:$J$1,0)),0)
 | 0 |  |  |  | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 |  |  |  |  | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 539033d1505928589-conditional-formatting-various-rules-in-one-cell-sample
Sheet: Sheet1

 |  |  |  |  |  | 1 | 1 - received | 2a | 2a - Received | 2b. | 2b - received | Step 2 SLA Met? | 3a. | 3b | 3c | 4a | 4a - received | 4b | 5a | 5a - received | 5b | 6a | 6a - received |  | Step 7
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 |  | 2017-07-05 00:00:00 |  | 2017-07-31 00:00:00 | Nearly | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-08-28 00:00:00 |  |  | 2017-09-15 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-08-22 00:00:00 |  | 2017-09-06 00:00:00 |  | Not received | No | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-08-25 00:00:00 |  |  | 2017-09-16 00:00:00
 |  |  |  |  |  | 2017-06-30 00:00:00 | 2017-07-11 00:00:00 |  | 2017-07-20 00:00:00 |  | 2017-07-24 00:00:00 | Yes | 2017-07-07 00:00:00 | 2017-08-01 00:00:00 | 2017-08-14 00:00:00 |  |  | 2017-08-25 00:00:00 |  | 2017-09-01 00:00:00 |  |  | 2017-09-17 00:00:00
 |  |  |  |  |  |  | Row Labels | Count of Step 2 SLA Met?
 |  |  |  |  |  |  | Nearly | 1
 |  |  |  |  |  |  | No | 1
 |  |  |  |  |  |  | Yes | 1
 |  |  |  |  |  |  | Grand Total | 3
Spreadsheet: 760530d1640272391-improve-formula-to-check-for-dates-within-a-range-leave-sample
Sheet: CALENDAR

HOLIDAY PLANNER
 | January 2022 | Remaining Balance | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00
SITE 1 | Staff Name
SITE 2
SITE 3
SITE 4
SITE 5
CASUAL
Spreadsheet: 600009d1543417526-need-to-calculate-different-pay-periods-for-different-pay-rates-excel-help-11-28-18
Sheet: Ingrid Theron

[NAME]
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  | Day Hours | 07:00:00 | 21:00:00
Time In | 03:00:00 | 01:00:00 | 21:00:00 | 13:00:00 |  |  |  |  |  |  | Night Hours | 21:00:00 | 07:00:00
Time Out | 09:00:00 | 05:00:00 | 04:00:00 | 17:00:00
Time In |  |  |  |  |  |  |  |  |  |  | Cleaning hours are subtracted from the period that has the most hours. Daily
Time Out
Time In
Time Out
Total Hours
Cleaning Hours | 2 | 2 | 2 | 2
Nanny Day
Nanny Night
Cleaning Day
Cleaning Night
What I would like them to be
Nanny Day | 2Hrs |  |  | 2
Nanny Night | 2Hrs | 2 | 5
Cleaning Day | 0 |  |  | 2
Cleaning Night | 2Hrs | 2 | 2
Spreadsheet: 205774d1357900887-conditional-formation-calander
Sheet: Sheet1

 | Date | WeekDay | Add Appointment
 | 1
 | 4
 | 7
 | 10
 | 13
 | 16
 | 19
 | 22
 | 25
 | 28
 | Weekdays
 | 2013 | 1
 |  |  |  |  |  |  | Amit……..!!!!!!!!!
 |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 1 |  |  | Day
 |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 2 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 3 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 4 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | May | 5 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Jun | 6 |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Jul | 7 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Aug | 8 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Sep | 9 |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | Oct | 10 |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | Nov | 11 |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Dec | 12 |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 2015 |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | 2016 |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023 |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  | 2024 |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2025 |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2026 |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 2027 |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | 2028 |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  | 2029 |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  | 2030 |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | 2031 |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | 2032 |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2033
 |  |  |  |  |  |  |  |  |  |  |  |  | 2034
 |  |  |  |  |  |  |  |  |  |  |  |  | 2035
 |  |  |  |  |  |  |  |  |  |  |  |  | 2036
 |  |  |  |  |  |  |  |  |  |  |  |  | 2037
 |  |  |  |  |  |  |  |  |  |  |  |  | 2038
 |  |  |  |  |  |  |  |  |  |  |  |  | 2039
 |  |  |  |  |  |  |  |  |  |  |  |  | 2040
 |  |  |  |  |  |  |  |  |  |  |  |  | 2041
 |  |  |  |  |  |  |  |  |  |  |  |  | 2042
 |  |  |  |  |  |  |  |  |  |  |  |  | 2043
 |  |  |  |  |  |  |  |  |  |  |  |  | 2044
 |  |  |  |  |  |  |  |  |  |  |  |  | 2045
 |  |  |  |  |  |  |  |  |  |  |  |  | 2046
 |  |  |  |  |  |  |  |  |  |  |  |  | 2047
 |  |  |  |  |  |  |  |  |  |  |  |  | 2048
 |  |  |  |  |  |  |  |  |  |  |  |  | 2049
 |  |  |  |  |  |  |  |  |  |  |  |  | 2050
Spreadsheet: 762970d1641920640-sum-of-values-across-multiple-sheets-morayman-sum-of-vls-mltpl-sheets
Sheet: JAN

2022-12-28 00:00:00 |  |  | 2500
2022-01-01 00:00:00 |  |  | 3500
2022-01-01 00:00:00 |  |  | 932.45
2022-01-01 00:00:00 |  |  | 1284
2022-01-01 00:00:00 |  |  | 750
2022-01-01 00:00:00 |  |  | 20
2022-01-01 00:00:00 |  |  | 350
2022-01-01 00:00:00 |  |  | 550
2022-01-02 00:00:00 |  |  | 4.037696
2022-01-04 00:00:00 |  |  | 150
2022-01-04 00:00:00 |  |  | 11
2022-01-06 00:00:00 |  |  | 2278.62
2022-01-08 00:00:00 |  |  | 80
2022-01-08 00:00:00 |  |  | 80
2022-01-10 00:00:00 |  |  | 7
2022-01-13 00:00:00 |  |  | 16.98
2022-01-15 00:00:00 |  |  | 16
2022-01-16 00:00:00 |  |  | 300
2022-01-18 00:00:00 |  |  | 155.85
2022-04-01 00:00:00 |  |  | 1250
2022-12-29 00:00:00 |  |  | 54.01600000000001
2023-01-02 00:00:00 |  |  | 750
2023-01-06 00:00:00 |  |  | 2323
2023-01-09 00:00:00 |  |  | 750
2023-01-16 00:00:00 |  |  | 750
2023-01-23 00:00:00 |  |  | 750
Spreadsheet: 157673d1337833351-sales-per-month-and-division-formula-test
Sheet: Sheet1

 | Month | Sales | Division
 |  |  |  |  |  |  |  | North | South | East | West
 | April | 1856 | North |  |  |  | January
 | May | 1188 | South |  |  |  | February
 | June | 698 | North |  |  |  | March
 | July | 1005 | South |  |  |  | April
 | August | 694 | North |  |  |  | May
 | September | 221 | South |  |  |  | June
 | October | 1860 | North |  |  |  | July
 | November | 1374 | South |  |  |  | August
 | December | 1823 | North |  |  |  | September
 | January | 1039 | South |  |  |  | October
 | February | 205 | North |  |  |  | November
 | March | 234 | South |  |  |  | December
 | April | 1222 | North
 | May | 201 | South
 | June | 1568 | North
 | July | 226 | North
 | August | 601 | South
 | September | 348 | North
 | October | 511 | East
 | November | 762 | West
 | December | 1373 | East
 | January | 1222 | West
 | February | 971 | East
 | March | 1539 | West
 | April | 1347 | East
 | May | 30 | West
 | June | 969 | East
 | July | 1865 | West
 | August | 902 | East
 | September | 684 | West
 | October | 1966 | East
 | November | 1661 | West
 | December | 1909 | East
 | January | 1487 | West
 | February | 1310 | East
 | March | 299 | West
 | April | 535 | East
 | May | 659 | West
 | June | 113 | East
 | July | 829 | West
 | August | 575 | East
 | September | 709 | West
 | October | 155 | East
 | November | 1280 | West
 | December | 701 | East
 | January | 919 | West
 | February | 10 | East
Spreadsheet: hunter_shively__12676__11-13 Enovate
Sheet: ENOVATE DPR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of November 13, 2001
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
ENOVATE |  |  |  |  |  |  |  |  |  |  |  | 92.34828777000914 | 72.39169608000722 | 894.7447368580084 | -3312.255263141992 | -3312.064263141991
GAS TRADING |  | -1.046389450094559 | 10 Bcf |  | 2.6502565306119 | 20 Bcf |  | 109.23835754681 |  | 2000 |  | 92.34828777000914 | 72.39169608000722 | 894.7447368580084 | -3312.255263141992 | -3312.064263141991
Short Term Trading |  | -0.6807123825000002 |  |  |  |  |  | 109 |  | 2000 | 92 | 92.34828777000914 | 72.39169608000722 | 894.7447368580084 | -3312.255263141992 | -3312.064263141991
Long Term Trading |  | -0.365677067594559 |  |  |  |  |  |  |  | -2000 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 65056d1265819004-how-to-make-a-booking-planning-report-testbookings2010
Sheet: BookingList

Aprt | [NAME] | [NAME] | Nights | Errors
C1A | 2010-04-29 00:00:00 | 2010-05-10 00:00:00
C1A | 2010-05-15 00:00:00 | 2010-05-18 00:00:00
C1C | 2010-05-22 00:00:00 | 2010-05-25 00:00:00
C1D | 2010-05-01 00:00:00 | 2010-05-15 00:00:00
C1E | 2010-05-13 00:00:00 | 2010-05-15 00:00:00
C1E | 2010-05-05 00:00:00 | 2010-05-12 00:00:00
C1A | 2010-05-21 00:00:00 | 2010-05-28 00:00:00
C1G | 2010-05-01 00:00:00 | 2010-05-15 00:00:00
C1E | 2010-05-18 00:00:00 | 2010-05-23 00:00:00
C1C | 2010-05-13 00:00:00 | 2010-05-19 00:00:00
C1A | 2010-05-15 00:00:00 | 2010-05-18 00:00:00 |  | Error attempting to book C1A for arrival on 5/15/2010 and departure on 5/18/2010; already booked for 5/15/2010 | Error case for testing
ABC | 2010-04-29 00:00:00 | 2010-05-10 00:00:00 |  | Did not find apartment ABC in Planning sheet. | Error case for testing
C1A | 2010-01-01 00:00:00 | 2010-05-10 00:00:00 |  | [NAME] date for C1A of 1/1/2010 is earlier than earliest date 4/29/2010 in Planning sheet. | Error case for testing
C1A | 2010-04-29 00:00:00 | 2011-01-01 00:00:00 |  | Departure date for C1A of 1/1/2011 is later than latest date 4/29/2010 in Planning sheet. | Error case for testing
C1A | 2010-05-10 00:00:00 | 2010-04-29 00:00:00 |  | Departure date for C1A of 4/29/2010 is the same as or earlier than arrival date of 5/10/2010. | Error case for testing
Spreadsheet: 0903cdb3-20a4-45ce-b24f-58aefbe8e4bd
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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 | Unnamed: 14
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2011/12 | 1140.6 | 1080.6 | 3385.702387562465 | 1515.939 | 3658.59 | 254 | 5428.529 |  | 2805 | 603.601 | 471.5970000000003 | 545 | 4425.198 | 1003.331
2012/131 | 1638 | 1608 | 4192.412935323383 | 1003.331 | 6741.4 | 100 | 7844.731 |  | 2832 | 675 | 603.7309999999998 | 1200 | 5310.731 | 2534
2013/142 | 1191 | 1167 | 3800.342759211654 | 2534 | 4435 | 65 | 7034 |  | 2915 | 577 | 460 | 650 | 4602 | 2432
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-06-13 11:05:04.160000
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: CollegeSource

CollegeSource
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 price | Price per search
College Source
Searches | 9 | 86 | 37 | 18 | 21 | 25 | 23 | 23 | 34 | 28 | 42 | 52 |  | 1334
Service Errors | 2 | 89 | 47 | 34 | 11 | 39 | 79 | 24 | 62 | 90 | 183 | 370
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COUNTER-Compliant?: | No
Spreadsheet: 740847d1626628511-how-to-change-cell-color-when-value-avove-zero-budget-master
Sheet: House Payment

Payment # | Balance | Interest For Month | Monthly Payment | End Balance | Date Payment Paid | E-Pay # | Additional Money Paid On Principle | Date Additional Money Paid | Check or E-Pay # or additional [NAME] | Amount Paid | Total Interest Paid For Year
1
2
3 |  |  |  |  |  |  |  |  |  |  | Loan Amount
4 |  |  |  |  |  |  |  |  |  |  | Interest Rate %
5 |  |  |  |  |  |  |  |  |  |  | # of Months
6 |  |  |  |  |  |  |  |  |  |  | Account #
7 |  |  |  |  |  |  |  |  |  |  | Total Paid | 0
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
Spreadsheet: 736476d1623676176-countif-formula-with-dates-solutionexforum
Sheet: Voucher

Voucher |  |  | Each Voucher is for 1 "Stay"
Check in | Address
 | Brussels
Check out
Voucher
Check in | Address
 | Berlin
Check out
 |  | ERROR -- The Check Out Date should be on the 30th but since the person checks in twice to Berlin but in between that, goes to Paris for two days.
Voucher
Check in | Address
 | Paris
Check out
Voucher
Check in | Address
 | Berlin
Check out
Spreadsheet: 60063d1260572808-use-lookups-to-change-a-value-in-the-lookup-table-example-lookup
Sheet: Stock Table

Barcode | Item Discription | Price | Stock QTY
1 | Skins Top Mens | 40 | 4
2 | Runners Bag | 20 | 2
3 | Nike Tank Top Wmns | 35 | 1
4 | Asics 2140 Shoe | 80 | 0
5 | 12mm Spikes | 3.5 | 9
6 | 500ml Water Bottle | 1.5 | 15
Barcode | Item Discription | Price |  | Qty | Amount
1 | Skins Top Mens | 40 |  | 1 | 40
4 | Asics 2140 Shoe | 80 |  | 3 | 240
3 | Nike Tank Top Wmns | 35 |  | 1 | 35
6 | 500ml Water Bottle | 1.5 |  | 1 | 1.5
 |  |  | Total |  | 316.5
Spreadsheet: 267996d1380342813-i-cant-accumulate-data-of-daily-production-report-into-monthly-production-report-helpp-problem
Sheet: Daily Production report (DPR) 

 | Date | 2013-09-26 00:00:00
 |  |  |  | Daily Production report
 |  | Prudction
 | M1
 | M3
 | PD
 | Total
Objective: | Converting daily production report into monthly production report
[NAME]:
This is report genereated from another sheet (lets call it sheet A)
In this report, No data is eneterd manually. Data is picked from Sheet A which is manually updated Daily
So, Daily prodcution report will automaticlly change each day as new data will be enetered in Sheet A
Requirement and explanation
I want that this data be automatically entered in sheet named "Monthly production Report" (MPR)in the format given.
Explaining it, today is 26 sep. so this data should automaticllly be filled against 26th sep.
Tomorrow date will be 27th sep here in this sheet and there will be new data picked from [NAME]
I want that MPR should retain values of 26th sep. MOREOVER  values of 27th sep in this sheet(DPR) be added to MPR against 27 sep and so on.
So in this way DPR data will keep accumulating in MPR and a monthly report could be genereated.
Restrictions:
You are not allowed to use macros
No copy pasting.
Reason:
Person who will be using report wont understand macros
I don’t want him to enter data manully in these reports as he may tweek with it to increase his performance
Spreadsheet: 215812d1361491870-auto-sum-grouping-by-row-based-on-month-sumbymonth
Sheet: Sheet1

Date | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | 2013-01-06 00:00:00 | 2013-01-13 00:00:00 | 2013-01-20 00:00:00 | 2013-01-27 00:00:00 | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2013-03-31 00:00:00 | 2013-04-07 00:00:00 | 2013-04-14 00:00:00 | 2013-04-21 00:00:00 | 2013-04-28 00:00:00 | 2013-05-05 00:00:00 | 2013-05-12 00:00:00 | 2013-05-19 00:00:00 | 2013-05-26 00:00:00 | 2013-06-02 00:00:00 | 2013-06-09 00:00:00 | 2013-06-16 00:00:00 | 2013-06-23 00:00:00 | 2013-06-30 00:00:00 | 2013-07-07 00:00:00 | 2013-07-14 00:00:00 | 2013-07-21 00:00:00 | 2013-07-28 00:00:00 | 2013-08-04 00:00:00 | 2013-08-11 00:00:00 | 2013-08-18 00:00:00 | 2013-08-25 00:00:00 | 2013-09-01 00:00:00 | 2013-09-08 00:00:00 | 2013-09-15 00:00:00 | 2013-09-22 00:00:00 | 2013-09-29 00:00:00 | 2013-10-06 00:00:00 | 2013-10-13 00:00:00 | 2013-10-20 00:00:00 | 2013-10-27 00:00:00 | 2013-11-03 00:00:00
Actual Cuml Hours | #N/A | 50 | 150 | 450 | 650 | 850 | 1080 | 1100 | 1100 | 1200 | 1500 | 1800 | 2300 | 2550 | 8550 | 12550 | 17550 | 17550 | 17550 | 17550 | 17560 | 17600 | 17620 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | 21 | 262 | 394 | 394 | 486 | 670 | 670 | 670 | 737 | 1125 | 1468 | 1945 | 2200 | 8834 | 14933 | 17778 | 19892 | 24288 | 29235 | 34618 | 39352 | 44169 | 48629 | 52753 | 56765 | 60099 | 63989 | 67943 | 70775 | 72157 | 72947 | 73737 | 74527 | 75684 | 78185 | 80962 | 83566 | 86079 | 88452 | 90485 | 92044 | 92515 | 92986 | 93457 | 93760 | #N/A | #N/A | #N/A | #N/A
Forecast Cuml Hours | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 17620 | 55643 | 59777 | 64067 | 68667 | 73007 | 77161 | 80337 | 81719 | 82509 | 83299 | 84094 | 85261 | 87762 | 90862 | 93865 | 97007 | 99459 | 101862 | 103450 | 104050 | 104650 | 105150 | 105453 | 105553 | 105653 | #N/A | #N/A
Earned | #N/A | 78.75 | 236.25 | 409.5 | 598.5 | 819 | 1055.25 | 1307.25 | 1590.75 | 1905.75 | 2412.15 | 3110.43 | 3856.44 | 4921.77 | 6066.809999999999 | 7562.670000000001 | 9153.990000000002 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 714726d1611337027-custom-time-formatting-paybonusforefproperresults
Sheet: Sheet1

Working time | Needed Result | Bo_Ry | MrShortyw/fpe | Bo_Ryw/fpe
7:00:00 | 8:00:00
7:15:00 | 8:00:00
7:30:00 | 8:00:00
7:45:00 | 8:00:00
8:00:00 | 8:00:00
8:15:00 | 8:23:00
8:30:00 | 8:45:00
8:45:00 | 9:08:00
9:00:00 | 9:30:00
9:15:00 | 9:53:00
9:30:00 | 10:15:00
9:45:00 | 10:38:00
10:00:00 | 11:00:00
10:15:00 | 11:23:00
10:30:00 | 11:45:00
10:45:00 | 12:08:00
11:00:00 | 12:30:00
11:15:00 | 12:53:00
11:30:00 | 13:15:00
11:45:00 | 13:38:00
12:00:00 | 14:00:00
12:15:00 | 14:23:00
12:30:00 | 14:45:00
Spreadsheet: 49683d1249020104-can-we-unmerge-words-with-the-help-of-any-formula-unmerge-data
Sheet: Sheet1

Complete address | Address[1] | Address[2] | Address[3] | Address[4] | [NAME]]
1st Floor, 2a Harrison Road, Erdington, West Midlands, B24 9AA | 1st Floor | 2a [NAME] | Erdingto | West Midland | B24 9AA
[NAME], 11-13 Ockford Road, Godalming, [NAME], GU7 1QU | [NAME] | 11-13 Ockford Roa | [NAME] | Surre | GU7 1QU
Wetherspoon House, Central Park, Reeds Cresent, Watford, [NAME] 1QH | Wetherspoon House | Central Par | [NAME] | Watfor | [NAME] 1QH
c/o [NAME], Property Dept, PO Box 170, Leeds,  LS2 8JF | c/o [NAME] | Property Dep | PO Box 17 | [NAME] | LS2 8JF
test1, test2 | test1 | test1 | test1 | test1 | test1
aaa