tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86056d1286034028-numbers-as-text-dropping-trailing-decimals-excelbad-1-
Sheet: Sheet2

Adobe Systems Incorporated | Adobe Anchor Service CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | [NAME] | 3# |  | 3 |  | 3
Adobe Systems Incorporated | Adobe CMaps CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe Color EU Extra Settings CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe Color JA Extra Settings CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe Color NA Recommended Settings CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | [NAME] | 1# |  | 1 |  | 1
Adobe Systems Incorporated | Adobe Default Language CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | [NAME] | 1# |  | 1 |  | 1
Adobe Systems Incorporated | Adobe ExtendScript Toolkit CS4 | 3.0.0# |  | 3.0.0 |  | 3.0.0
Adobe Systems Incorporated | Adobe Extension Manager CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe [NAME] 10 ActiveX | 10.1.82.76# |  | 10.1.82.76 |  | 10.1.82.76
Adobe Systems Incorporated | Adobe Fonts All | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe InDesign CS4 Application Feature Set Files (Roman) | 6.0# |  | 6.0 |  | 6.0
Adobe Systems Incorporated | Adobe InDesign CS4 Common Base Files | 6# |  | 6 |  | 6
Adobe Systems Incorporated | Adobe InDesign CS4 Icon Handler | 6# |  | 6 |  | 6
Adobe Systems Incorporated | [NAME] | 4.0.0# |  | 4.0.0 |  | 4.0.0
Adobe Systems Incorporated | Adobe Output Module | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe PDF Library Files CS4 | 9# |  | 9 |  | 9
Adobe Systems Incorporated | Adobe Search for Help | 1# |  | 1 |  | 1
Adobe Systems Incorporated | Adobe Service Manager Extension | 1.0# |  | 1.0 |  | 1.0
Adobe Systems Incorporated | Adobe Setup | 2.0# |  | 2.0 |  | 2.0
Adobe Systems Incorporated | Adobe SGM CS4 | 3.00# |  | 3.00 |  | 3.00
Adobe Systems Incorporated | Adobe SING CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | Adobe Type Support CS4 | 9# |  | 9 |  | 9
Adobe Systems Incorporated | Adobe Update Manager CS4 | 6.0.0# |  | 6.0.0 |  | 6.0.0
Adobe Systems Incorporated | Adobe WinSoft Linguistics Plugin | 1.1# |  | 1.1 |  | 1.1
Adobe Systems Incorporated | Adobe XMP Panels CS4 | 2# |  | 2 |  | 2
Adobe Systems Incorporated | AdobeColorCommonSetCMYK | 2# |  | 2 |  | 2
Adobe Systems Incorporated | AdobeColorCommonSetRGB | 2# |  | 2 |  | 2
Adobe Systems Incorporated | kuler | 2.00# |  | 2.00 |  | 2.00
Spreadsheet: 189383d1351175825-count-unique-cases-in-a-weekly-bucket-example
Sheet: Data

Case Number | Hours Worked | Date
HD56451 | 0.1 | 2012-07-26 00:00:00
HD56451 | 0.1 | 2012-07-26 00:00:00
HD56451 | 0.1 | 2012-07-26 00:00:00
HD5416 | 0.1 | 2012-07-26 00:00:00
HD152 | 0.1 | 2012-07-26 00:00:00
HD15698 | 0.05 | 2012-07-26 00:00:00
HD15698 | 0.5 | 2012-07-26 00:00:00
HD15264 | 0.1 | 2012-07-26 00:00:00
HD15264 | 0.2 | 2012-07-26 00:00:00
HD84591 | 0.1 | 2012-07-27 00:00:00
HD541 | 0.01 | 2012-07-27 00:00:00
HD5489 | 0.1 | 2012-07-27 00:00:00
HD4879 | 0.1 | 2012-07-28 00:00:00
HD4879 | 0.5 | 2012-07-28 00:00:00
HD5416 | 0.1 | 2012-07-28 00:00:00
HD5416 | 0.1 | 2012-07-28 00:00:00
HD56471 | 0.2 | 2012-07-28 00:00:00
HD591-001 | 0 | 2012-07-28 00:00:00
HD591-002 | 0.2 | 2012-07-28 00:00:00
HD59456 | 0.2 | 2012-07-28 00:00:00
HD5416-001 | 0.2 | 2012-07-28 00:00:00
HD6541 | 0.15 | 2012-07-29 00:00:00
HD569 | 0.5 | 2012-07-29 00:00:00
HD1154 | 0.1 | 2012-07-29 00:00:00
HD1154 | 0.2 | 2012-07-29 00:00:00
HD1154 | 0.1 | 2012-07-29 00:00:00
HD54698 | 0.01 | 2012-07-30 00:00:00
HD5461-002 | 0.1 | 2012-07-30 00:00:00
HD5461-002 | 0.1 | 2012-07-30 00:00:00
HD84561 | 0.5 | 2012-07-30 00:00:00
HD541631 | 0.1 | 2012-07-30 00:00:00
HD45815 | 0.1 | 2012-07-30 00:00:00
HD4581 | 0.2 | 2012-07-31 00:00:00
HD4581 | 0 | 2012-07-31 00:00:00
HD22546 | 0.2 | 2012-07-31 00:00:00
HD64915 | 0.15 | 2012-07-31 00:00:00
HD6499 | 0.5 | 2012-08-01 00:00:00
HD6499 | 0.1 | 2012-08-01 00:00:00
HD6499 | 0.2 | 2012-08-01 00:00:00
HD6499-01 | 0.1 | 2012-08-01 00:00:00
HD97415 | 0.5 | 2012-08-01 00:00:00
HD510 | 0.1 | 2012-08-01 00:00:00
HD9785 | 0.1 | 2012-08-02 00:00:00
HD9785 | 0.2 | 2012-08-02 00:00:00
HD9785 | 0 | 2012-08-02 00:00:00
HD6156 | 0.2 | 2012-08-02 00:00:00
HD1620 | 0.2 | 2012-08-02 00:00:00
HD6491 | 0.2 | 2012-08-02 00:00:00
HD6491 | 0.15 | 2012-08-02 00:00:00
HD6491 | 0.5 | 2012-08-02 00:00:00
HD51166 | 0.04 | 2012-08-02 00:00:00
Spreadsheet: 732127d1620781440-populate-data-validation-list-with-items-shorter-than-9-characters-in-range-conditional-data-validation-list-barth_nl-
Sheet: Sheet1

Select: |  |  |  | project / kostenplaats | D/V List
20.10.43 |  |  |  | algemene kosten-accountantskosten
 |  |  |  | algemene kosten-cursuskosten
 |  |  |  | [NAME] kosten
 |  |  |  | algemene kosten-overig
 |  |  |  | algemene [NAME]
 |  |  |  | kantoorkosten-automatisering
 |  |  |  | 20.10.43
 |  |  |  | kantoorkosten-contributies en abonnementen
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME] telefoonkosten
 |  |  |  | [NAME]
 |  |  |  | kantoorkosten-portokosten
 |  |  |  | 21.02.02
 |  |  |  | kantoorkosten-telefoonkosten
 |  |  |  | personeelskosten-managementvergoeding
 |  |  |  | personeelskosten-overige personeelskosten
 |  |  |  | verkoopkosten-diners en lunches
 |  |  |  | 20.11.46
 |  |  |  | verkoopkosten-marketingkosten
 |  |  |  | verkoopkosten-reis- en verblijfkosten
 |  |  |  | verkoopkosten-representatie |  | Target:
 |  |  |  | verkoopkosten-sales |  | Only add items to List that are shorter than 9 characters (like 20.10.43)
 |  |  |  | 21.01.01
 |  |  |  | 21.03.03
 |  |  |  | 21.03.05
 |  |  |  | 21.03.06
 |  |  |  | 21.03.07
 |  |  |  | 21.03.08
 |  |  |  | 21.05.09
Spreadsheet: 89205d1288957276-auto-populating-cells-book2
Sheet: sheet

ZONE: |  |  |  | SCHOOL: |  |  |  |  | EMIS NO. |  |  |  |  | NO. OF STDS. |  |  |  | HEAD TEACHER: |  |  |  |  |  |  |  |  | PEA:
ENROLMENT: |  |  |  | QUAL. TEACHERS: |  |  |  |  |  | NO. FEM. TEACHERS: |  |  |  |  |  | SMC CHAIR: |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCHOOL FUNDS SOURCES |  |  |  |  |  |  |  |  | SCHOOL FUNDS EXPENDITURES
NO. SMC-PTA MEETINGS HELD |  |  |  |  |  |  | % Double Orphans |  | 0 |  | % DOs RECEIVING BURSARIES |  |  | 0 |  |  |  | 1. PTA / SCHOOL CONTRIBUTIONS |  |  |  |  | MK |  |  |  | 1. QUALITY |  |  |  | MK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. ACCESS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. DIRECT SUPPORT |  |  |  |  | MK
NO. OF DESKS NEEDED |  |  |  |  |  |  |  |  | NO. OF TEXTBOOKS NEEDED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. GOVERNANCE |  |  |  | MK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. NGO/DONOR DONATIONS |  |  |  |  | MK |  |  |  | 4. EXAMINATIONS |  |  |  | MK
NO. OF SNE LEARNERS |  |  |  |  |  |  | SCHOOL HEALTH-NUTRITION SCORES |  |  |  |  |  |  |  | /50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. OTHER (specify) |  |  |  |  | MK |  |  |  | 5. OTHER (specify) |  |  |  | MK
NO. OF PEA SUPERVISORY VISITS |  |  |  |  |  |  |  |  | WATER SOURCES: |  |  |  |  |  |  |  |  | 5. TOTAL |  |  |  |  | MK |  |  |  | 6. TOTAL |  |  |  | MK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESOURCES NEEDED TO MEET NATIONAL STANDARDS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO. CLASS-ROOMS |  |  |  |  |  |  | NO. BURNT BRICKS |  |  |  | % SELECTED TO SS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR |  | ENROLMENT |  |  | NO. TEACHERS |  |  |  |  |  |  | NO. TOILETS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCHOOL PERFORMANCE OVER TIME |  |  |  |  |  |  |  |  | 2007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIP PRIORITIES (previous year) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIP TARGETS |  |  |  |  |  |  | SIP ACHIEVEMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.
Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: 3 2024 15Yr CF Tracking

15 Year Cash Flow Tracking - Adjusted Exp - Modified Levies
Year | Year To | Opening Balance | Total Levy Contributions | Macquarie Interest (after tax) | Anticipated Expenses | Actual Expenses | Closing Balance | % Variance in Annual Levy |  |  | Updated SFF based on Actuals from 2023 Financial Reports
 |  |  | ([NAME]. GST) | Invest 150K | ([NAME]. GST) | (Excl GST) |  |  |  |  | Starting position with no levy adjustments, using adjusted expenses from Sheet 1 SFF 2024
1 | 2023-12-31 00:00:00 | 242275 | 96558 | 3944 |  |  | 207372 | 0 |  |  | This is the "Do nothing" scenario, with no changes to existing investments or levies
2 | 2024-12-31 00:00:00 |  |  |  |  |  |  | 0
3 | 2025-12-31 00:00:00 |  |  |  |  |  |  | 0
4 | 2026-12-31 00:00:00 |  |  |  |  |  |  | 0
5 | 2027-12-31 00:00:00 |  |  |  |  |  |  | 0
6 | 2028-12-31 00:00:00 |  |  |  |  |  |  | 0
7 | 2029-12-31 00:00:00 |  |  |  |  |  |  | 0
8 | 2030-12-31 00:00:00 |  |  |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  |  |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  |  |  |  |  |  | 0
11 | 2033-12-31 00:00:00 |  |  |  |  |  |  | 0
12 | 2034-12-31 00:00:00 |  |  |  |  |  |  | 0
13 | 2035-12-31 00:00:00 |  |  |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  |  |  |  |  |  | 0
15 | 2037-12-31 00:00:00 |  |  |  |  |  |  | 0
 | Macquarie interest reinvested
Year | Year To | Opening Balance | Interest rate % pa | Macquarie Interest (after tax) | Closing Balance
1 | 2023-12-31 00:00:00 | 150000 | 0.0465 |  | 157573
2 | 2024-12-31 00:00:00 |  | 0.0465
3 | 2025-12-31 00:00:00 |  | 0.0465
4 | 2026-12-31 00:00:00 |  | 0.0465
5 | 2027-12-31 00:00:00 |  | 0.0465
6 | 2028-12-31 00:00:00 |  | 0.0465
7 | 2029-12-31 00:00:00 |  | 0.0465
8 | 2030-12-31 00:00:00 |  | 0.0465
9 | 2031-12-31 00:00:00 |  | 0.0465
10 | 2032-12-31 00:00:00 |  | 0.0465
11 | 2033-12-31 00:00:00 |  | 0.0465
12 | 2034-12-31 00:00:00 |  | 0.0465
13 | 2035-12-31 00:00:00 |  | 0.0465
14 | 2036-12-31 00:00:00 |  | 0.0465
15 | 2037-12-31 00:00:00 |  | 0.0465
Spreadsheet: 777523d1650452925-returning-a-value-based-on-percentage-range-jimboted
Sheet: Sheet1

Search Range |  | Return Range |  |  | Test | Return
0.75 | 1 | 0.05 | 0 |  | 0.28
0.5 | 0.749 | 0.15 | 0.1 |  | 0.45
0.5 | 0.5 | 0.2 | 0.2 |  | 0.1
0.25 | 0.499 | 0.4 | 0.25 |  | 0.8
0.051 | 0.25 | 0.7 | 0.4 |  | 0.5
0 | 0.05 | 0.7 | 0.7 |  | 0.04
Spreadsheet: 743154d1628253213-closing-rate-per-month-sample-55-
Sheet: Sheet1

Date? | Customer Name | Call Type? | Proposed Work ($) | Approved Work($) |  | Month | Close Rate %
2021-07-30 00:00:00 | Test Call | Service | 5200 | 4100 |  | 2021-01-01 00:00:00
2021-07-29 00:00:00 | [NAME] | Maintenance/System Check | 1350 | 978 |  | 2021-02-01 00:00:00
2021-07-28 00:00:00 | [NAME] | Service | 3675 | 3450 |  | 2021-03-01 00:00:00
2021-08-03 00:00:00 | Tough Call | Service | 5600 | 69 |  | 2021-04-01 00:00:00
2021-08-05 00:00:00 | [NAME] | Service | 4300 | 0 |  | 2021-05-01 00:00:00
2021-08-05 00:00:00 | [NAME] | Maintenance/System Check | 575 | 125 |  | 2021-06-01 00:00:00
2021-08-05 00:00:00 | Jonny grapeseed | Service | 7800 | 1250 |  | 2021-07-01 00:00:00
 |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  | 2021-12-01 00:00:00
Spreadsheet: 3868670f-af82-42d4-8589-595d0487ee3a
Sheet: Sheet1

 |  |  |  |  |  | Mitigate  impact of migration barriers | Re-naturation | Sediment management strategies | Natural water retention measures | Environmental flow | Other measures
Fish laders | 0.648 |  |  | Mitigate  impact of migration barriers | Removal of structures, weirs, barriers, and bank enforcement | 0.694
Bypass channels | 0.343 |  |  | mitigate  impact of migration barriers | Fish laders | 0.648
Habitat restoration, building spawning and breeding areas | 0.62 |  |  | mitigate  impact of migration barriers | Bypass channels | 0.343
Sediment management | 0.5 |  |  |  | Habitat restoration, building spawning and breeding areas |  | 0.62
Removal of structures, weirs, barriers, and bank enforcement | 0.694 |  |  |  | Restoration of bank structures |  | 0.537
Reconnection of meander bends or side arms | 0.333 |  |  |  | Reconnection of meander bends or side arms |  | 0.333
Lowering of river banks | 0.074 |  |  |  | Restoration of degraded bed structures |  | 0.389
Restoration of bank structures | 0.537 |  |  |  | Lowering of river banks |  | 0.074
Setting minimum ecological flow requirements | 0.38 |  |  |  | Sediment management |  |  | 0.5
Operational modifications for hydropeaking | 0.259 |  |  |  | Restoration of degraded bed structures |  |  | 0.389
 |  |  |  |  | Reduction or modification of dredging |  |  | 0.25
 |  |  |  |  | Inudation of flood plains |  |  |  | 0.185
Reduction or modification of dredging | 0.25 |  |  |  | Construction of retention basins |  |  |  | 0.12
Restoration of degraded bed structures | 0.389 |  |  |  | Setting minimum ecological flow requirements |  |  |  |  | 0.38
Remeandering of formerly straightened water courses | 0.324 |  |  |  | Operational modifications for hydropeaking |  |  |  |  | 0.259
Other | 0.593 |  |  |  | Other |  |  |  |  |  | 0.593
Spreadsheet: kate_symes__18190__EESSales_dailymarch
Sheet: 2-15

NP15 | 2001-02-15 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 442.08 | Fixed Off Peak | 350 |  |  |  | Fixed Peak | 421.8 |  | Fixed Off Peak | 318.08 |  |  | Fixed Peak | 421.8 | Fixed Off Peak | 318.08
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -9.43 | -9.43 |  |  | 1 | -314.02 | 0 | -54 | -269.84 |  |  | 1 | -2 | 0 | 0 | -2
2 | 0 | 0 | -8.54 | -8.54 |  |  | 2 | -315.27 | 0 | -54 | -259.09 |  |  | 2 | -1.96 | 0 | 0 | -1.96
3 | 0 | 0 | -8.11 | -8.11 | 0 |  | 3 | -315.03 | 0 | -44 | -253.86 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | 0 | 0 | -8.04 | -8.04 |  |  | 4 | -315.22 | 0 | -44 | -254.04 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | 0 | 0 | -8.38 | -8.38 |  |  | 5 | -315.49 | 0 | -44 | -266.31 |  |  | 5 | -1.96 | 0 | 0 | -1.96
6 | 0 | 0 | -10.85 | -10.85 |  |  | 6 | -312.75 | 0 | -54 | -299.57 |  |  | 6 | -2.05 | 0 | 0 | -2.05
7 | 0 | 0 | -14.81 | -14.81 |  |  | 7 | -256.84 | 0 | -54 | -293.66 |  |  | 7 | -2.23 | 0 | 0 | -2.23
8 | -0.12 | 0 | -17 | -17.12 |  |  | 8 | -254.39 | 0 | -54 | -325.21 |  |  | 8 | -2.32 | 0 | 0 | -2.32
9 | -0.33 | 0 | -17 | -17.33 |  |  | 9 | -254.11 | 0 | -54 | -350.93 |  |  | 9 | -2.33 | 0 | 0 | -2.33
10 | 0 | 0 | -16.22 | -16.22 |  |  | 10 | -255.41 | 0 | -54 | -368.23 |  |  | 10 | -2.28 | 0 | 0 | -2.28
11 | 0 | 0 | -16.18 | -16.18 |  |  | 11 | -255.07 | 0 | -54 | -378.89 |  |  | 11 | -2.28 | 0 | 0 | -2.28
12 | -0.36 | 0 | -17 | -17.36 |  |  | 12 | -254.19 | 0 | -54 | -382.01 |  |  | 12 | -2.32 | 0 | 0 | -2.32
13 | -0.24 | 0 | -17 | -17.24 |  |  | 13 | -254.19 | 0 | -54 | -384.01 |  |  | 13 | -2.33 | 0 | 0 | -2.33
14 | 0 | 0 | -16.77 | -16.77 |  |  | 14 | -254.73 | 0 | -54 | -383.55 |  |  | 14 | -2.31 | 0 | 0 | -2.31
15 | 0 | 0 | -16.27 | -16.27 |  |  | 15 | -255.03 | 0 | -54 | -379.85 |  |  | 15 | -2.28 | 0 | 0 | -2.28
16 | 0 | 0 | -16.47 | -16.47 |  |  | 16 | -255.21 | 0 | -54 | -375.03 |  |  | 16 | -2.29 | 0 | 0 | -2.29
17 | 0 | 0 | -16.79 | -16.79 |  |  | 17 | -254.1 | 0 | -54 | -366.92 |  |  | 17 | -2.3 | 0 | 0 | -2.3
18 | -1.55 | 0 | -17 | -18.55 |  |  | 18 | -252.86 | 0 | -54 | -367.68 |  |  | 18 | -2.38 | 0 | 0 | -2.38
19 | -3.52 | 0 | -17 | -20.52 |  |  | 19 | -250.56 | 0 | -54 | -362.37 |  |  | 19 | -2.46 | 0 | 0 | -2.46
20 | -2.01 | 0 | -17 | -19.01 |  |  | 20 | -252.21 | 0 | -54 | -350.03 |  |  | 20 | -2.4 | 0 | 0 | -2.4
21 | -0.64 | 0 | -17 | -17.64 |  |  | 21 | -253.49 | 0 | -54 | -338.31 |  |  | 21 | -2.34 | 0 | 0 | -2.34
22 | 0 | 0 | -16.23 | -16.23 |  |  | 22 | -255.14 | 0 | -54 | -311.96 |  |  | 22 | -2.29 | 0 | 0 | -2.29
23 | 0 | 0 | -13.86 | -13.86 |  |  | 23 | -309.67 | 0 | -54 | -325.49 |  |  | 23 | -2.18 | 0 | 0 | -2.18
24 | 0 | 0 | -11.32 | -11.32 |  |  | 24 | -312.33 | 0 | -54 | -293.15 |  |  | 24 | -2.08 | 0 | 0 | -2.08
Spreadsheet: 807455d1669907628-attendance-times-per-month-from-sap-stamping-time-extract-attendance-times-september-2022
Sheet: Analysis

Example for a result form
Date | Number of present people | Number of working hours
2022-09-01 00:00:00 | ??? | ???
2022-09-02 00:00:00 | ??? | ???
2022-09-03 00:00:00 | ??? | ???
2022-09-04 00:00:00 | ??? | ???
2022-09-05 00:00:00 | ??? | ???
2022-09-06 00:00:00 | ??? | ???
2022-09-07 00:00:00 | ??? | ???
2022-09-08 00:00:00 | ??? | ???
2022-09-09 00:00:00 | ??? | ???
2022-09-10 00:00:00 | ??? | ???
2022-09-11 00:00:00 | ??? | ???
2022-09-12 00:00:00 | ??? | ???
2022-09-13 00:00:00 | ??? | ???
2022-09-14 00:00:00 | ??? | ???
2022-09-15 00:00:00 | ??? | ???
2022-09-16 00:00:00 | ??? | ???
2022-09-17 00:00:00 | ??? | ???
2022-09-18 00:00:00 | ??? | ???
2022-09-19 00:00:00 | ??? | ???
2022-09-20 00:00:00 | ??? | ???
2022-09-21 00:00:00 | ??? | ???
2022-09-22 00:00:00 | ??? | ???
2022-09-23 00:00:00 | ??? | ???
2022-09-24 00:00:00 | ??? | ???
2022-09-25 00:00:00 | ??? | ???
2022-09-26 00:00:00 | ??? | ???
2022-09-27 00:00:00 | ??? | ???
2022-09-28 00:00:00 | ??? | ???
2022-09-29 00:00:00 | ??? | ???
2022-09-30 00:00:00 | ??? | ???
Spreadsheet: 843164d1695113151-calculate-overlap-costs-with-date-paramaters-overlap-cost
Sheet: Sheet1

 |  |  | Period Start Date | Period End
 |  |  | 2023-08-28 00:00:00 | 2023-09-27 00:00:00 |  |  | No Days
 |  | ID  Old | Exit Date | Monthly Cost |  | ID New | Start Date | Answer | Comment
 |  | A | 2023-10-20 00:00:00 | 1000 |  | E | 2023-07-01 00:00:00 | 1000 | Full Period as ID A overlapping ID E for full timeframe
 |  | B | 2023-09-30 00:00:00 | 1100 |  | F | 2023-07-01 00:00:00 |  | Full Period as ID B overlapping ID E for full timeframe
 |  | C | 2023-07-29 00:00:00 | 1200 |  | G | 2023-09-01 00:00:00 | 0 | ID Exited 19 Jul so outside Period (28th Aug - 27sep)
 |  | D | 2023-09-19 00:00:00 | 1300 |  | H | 2023-09-01 00:00:00 |  | ID H in place for 19 days during Period (28th - 27 Sep)
Spreadsheet: 798419d1664467296-subtracting-outgoing-amounts-from-multiple-cells-until-exhausted-example
Sheet: Sheet1

 |  | Date | Amount | Remaining |  |  |  | Deduction
 |  | 2022-09-01 00:00:00 | 200000 |  |  |  |  | 50000
 |  | 2022-09-25 00:00:00 | 100000 |  |  |  |  | 50000
 |  | 2022-09-28 00:00:00 | 150000 |  |  |  |  | 50000
 |  | 2022-09-28 00:00:00 | 200000 |  |  |  |  | 50000
 |  | 2022-10-01 00:00:00 | 125000 |  |  |  |  | 35000
 |  | Want to be able to continue both columns onwards so more deductions in column I and more additions in column D
 |  | Want the deductions when added to start to be taken from the uppermost values so the first 4 x 50000 would exhaust the 20000 value in D8 and then the 35000 would get taken from the 100000 in D9 and then onwards including more additions and deductions
Spreadsheet: 85292d1285324863-dynamic-sumif-ef-dynamic-sumif
Sheet: ZoneCluster

 | Circle | Zone
 | ASSAM | BONGAIGAON
 | ASSAM | GUWAHATI
 | ASSAM | JORHAT
 | ASSAM | SHILLONG
 | ASSAM | TEZPUR
 | ASSAM | OTHER
 | BH | BHAGALPUR
 | BH | CHAMPARAN
 | BH | CHHAPRA
 | BH | DARBHANGA
 | BH | DHANBAD
 | BH | SASARAM
 | BH | PATNA
 | BH | PURNEA
 | BH | RANCHI
 | BH | OTHER
 | HP | BADDI
 | HP | DHARAMSHALA
 | HP | OTHER
 | HR | HISSAR
 | HR | KARNAL
 | HR | ROHTAK
 | HR | OTHER
 | JK | ANANTNAG
 | JK | BARAMULLA
 | JK | BATOTE
 | JK | JAMMU
 | JK | SRINAGAR
 | JK | OTHER
 | MP | BHOPAL
 | MP | BILASPUR
 | MP | GWALIOR
 | MP | INDORE N
 | MP | INDORE S
 | MP | JABALPUR
 | MP | RAIPUR
 | MP | SATNA
 | MP | OTHER
 | NES | MANIPUR
 | NES | MIZORAM
 | NES | [NAME]
 | NES | SHILLONG
 | NES | TEZPUR
 | NES | TRIPURA
 | NES | OTHER
 | ORS | BALASORE
 | ORS | BERHAMPUR
 | ORS | BHAWANIPATNA
 | ORS | BHUBANESWAR
 | ORS | SAMBALPUR
 | ORS | OTHER
 | RAJ | BARMER
 | RAJ | BHARATPUR
 | RAJ | BIKANER
 | RAJ | JAIPUR
 | RAJ | KOTA
 | RAJ | UDAIPUR
 | RAJ | OTHER
 | UPE | ALLAHABAD
 | UPE | FAIZABAD
 | UPE | GORAKHPUR
 | UPE | JHANSI
 | UPE | KANPUR
 | UPE | LUCKNOW
 | UPE | VARANASI
 | UPE | OTHER
 | UPW | AGRA
 | UPW | BAREILLY
 | UPW | DEHRADUN
 | UPW | MEERUT
 | UPW | MORADABAD
 | UPW | OTHER
Spreadsheet: 870433d1716952570-show-value-blank-or-please-select-slicers-when-some-of-slicer-not-selected-example
Sheet: s2

Degree | 1 |  |  |  | الدرجة | الثانية |  |  |  | الدرجة | الثالثة |  |  |  | الدرجة | الرابعة
Variable | unmarried | married |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج
الراتب الأساسي |  |  |  |  | الراتب الأساسي |  |  |  |  | الراتب الأساسي |  |  |  |  | الراتب الأساسي | 8096 | 8096
بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن | 3025 | 3850
غلاء المعيشة |  |  |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة | 990 | 990
بدل الإنتقال |  |  |  |  | بدل الإنتقال |  |  |  |  | بدل الإنتقال |  |  |  |  | بدل الإنتقال | 2843 | 2843
[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME]
الدرجة | الخامسة |  |  |  | الدرجة | [NAME] |  |  |  | الدرجة | [NAME] |  |  |  | الدرجة | الثامنة
البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج
الراتب الأساسي | 6749 | 6749 |  |  | الراتب الأساسي | 5467 | 5467 |  |  | الراتب الأساسي | 4395 | 4395 |  |  | الراتب الأساسي | 3691 | 3691 |  |  | الراتب الأساسي
بدل السكن |  | 3850 |  |  | بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن
غلاء المعيشة | 990 | 990 |  |  | غلاء المعيشة | 990 | 990 |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة
بدل الإنتقال | 2362 | 2362 |  |  | بدل الإنتقال | 1914 | 1914 |  |  | بدل الإنتقال | 1978 | 1978 |  |  | بدل الإنتقال | 1661 | 1661 |  |  | بدل الانتقال
[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | بدل ماء وكهرباء | 300 | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | بدل الانتقال الإضافي | 400 | 400
الدرجة | التاسعة |  |  |  | الدرجة | العاشرة |  |  |  | الدرجة | الحادية عشر |  |  |  | الدرجة | الثانية عشر
البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج
الراتب الأساسي | 2987 | 2987 |  |  | الراتب الأساسي | 2459 | 2459 |  |  | الراتب الأساسي | 2373 | 2373 |  |  | الراتب الأساسي | 2104 | 2104
بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن |  |  |  |  | بدل السكن
غلاء المعيشة |  |  |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة |  |  |  |  | غلاء المعيشة | 440 | 440
بدل الإنتقال | 1344 | 1344 |  |  | بدل الإنتقال | 1107 | 1107 |  |  | بدل الإنتقال | 1068 | 1068 |  |  | بدل الإنتقال | 947 | 947
[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME]
الدرجة | الثالثة عشر |  |  |  | الدرجة | الرابعة
البنود | [NAME] | متزوج |  |  | البنود | [NAME] | متزوج
الراتب الأساسي | 1744 | 1744 |  |  | الراتب الأساسي | 1474 | 1474
بدل السكن |  |  |  |  | بدل السكن | 660
غلاء المعيشة | 440 | 440 |  |  | غلاء المعيشة | 440 | 440
بدل الإنتقال | 784 | 784 |  |  | بدل الإنتقال | 663 | 663
[NAME] |  |  |  |  | [NAME]
Spreadsheet: 74884d1275425476-combining-data-of-varying-lengths-destination
Sheet: Data1

 |  |  |  |  |  | Key | index