tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707723d1607432118-if-function-formula-returning-value-from-different-sheet-based-on-text-in-cell-risk-figures
Sheet: Sheet2

 | Q1
 | Target | £ | Risk position
Manufacturer Standards | 250 | 0 | At Risk
Quarterly Sales Volume | 187500 | 0 | At risk
Digital Learning | 0.2 | 0.2 | No Risk
 | 0.7 | 0.7 | No Risk
Training | 37500 | 0 | No Risk
5 On line 40 Points and 2 Physical Shops 60 Points | 0.9 | 0.9 | No Risk
Mystery Shop | 75000 | 0 | No Risk
Month  1  Target  must be done if Achieved | 70 | 70 | No Risk
Month  1  Target   not  achieved | 70 | 100 | No Risk
Monthly Target | 37500 | 0 | No Risk
GKL   7 Ser &X7 8Ser &M8 &i8 | Yes | Yes | No Risk
GKL   7 Ser &X7 8Ser &M8 &i9 | Yes | Yes | No Risk
Catch up of Previous Quarter provided YTD | Yes | Yes | No Risk
[NAME] (GKL) - based on wholesales | 37500 | 0 | No Risk
 | Yes | Yes | No Risk
 | Yes | Yes | No Risk
 | Yes | Yes | No Risk
 | Yes | Yes | No Risk
Catch up of Previous Quarter provided YTD | Yes | Yes | No Risk
Quality of Revenue | 37500 | 0 | No Risk
[NAME] | Yes | Yes | No Risk
[NAME] | Yes | Yes | No Risk
Customer bonus  will be paid once PQs have been met AND | Yes | Yes | No Risk
Quarterly Customer Action Plan  will be required for Sales  and | Yes | Yes | No Risk
Voice of the customer | 37500 | 0 | No Risk
PHEV  Mix  does not include  BMWi | Yes | Yes | No Risk
PHEV  Mix  does not include  BMWi | Yes | Yes | No Risk
Catch up of Previous Quarter provided YTD | Yes | Yes | No Risk
[NAME] (PHEV) | 37500 | 0 | No Risk
BMW Area Manager  will agree Action plan at the start of the | Yes | Yes | No Risk
 | Yes | Yes | No Risk
End of quarter  review  with BMW  Area Manager where he can | Yes | Yes | No Risk
Retailer KPI perfomance Management | 37500 | 0 | No Risk
Adhere to   all BMW  brand guidelines  and  premium | Yes | Yes | No Risk
Retail Marketing | 75000 | 0 | No Risk
Total 8% | 600141.8 | 171.8
Spreadsheet: 820886d1678322170-need-help-with-a-formula-example
Sheet: Example

[NAME] Participant Timesheet
Month:
Name:
Date of Service | Time In | Time Out | Total Hours | Days Billed | $ [NAME]
1 | 07:00:00 | 15:00:00 |  | 1
 | 08:00:00 | 11:00:00 |  | 1
 |  |  |  | 0
 |  |  |  | 0
 | 08:30:00 | 16:45:00 |  | 1
 | 09:45:00 | 13:35:00 |  | 1
 | 11:00:00 | 16:00:00 |  | 1
 | 09:00:00 | 16:30:00 |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | 08:15:00 | 12:00:00 |  | 1
 | 07:55:00 | 13:25:00 |  | 1
 | 10:00:00 | 17:15:00 |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
*Over four (4) hours, shall pay the full rate |  |  | 57.2
*Four (4) hours or less,  shall pay 1/2 the daily rate |  |  | 28.6
 |  |  |  | Total invoice:
Spreadsheet: 725705d1616798756-how-to-pull-all-rows-of-data-where-specific-value-is-found-in-a-column-exampleexcelsheet
Sheet: Sheet1

Name | Color | Food | Book | Home | Goal | Assigned To:
[NAME] | Red | Burger | Catcher and the Rye | PA | 10 | [NAME]
[NAME] | Blue | Burger | Catcher and the Rye | NY | 10 | [NAME]
[NAME] | Purple | Burger | Catcher and the Rye | NY | 10 | [NAME]
Lacy Wellington | Magenta | [NAME] | Catcher and the Rye | NJ | 10 | [NAME]
[NAME] | Orange | Quesadilla | Catcher and the Rye | ND | 20 | George
[NAME] | Blue | Burger | Old School | CA | 20 | [NAME]
[NAME] | Orange | Burger | Old School | AK | 20 | [NAME]
[NAME] | Red | Burger | Old School | NY | 304 | [NAME]
[NAME] | Pink | Burger | 1984 | OH | 303 | [NAME]
[NAME] | Purple | [NAME] | Catcher and the Rye | OH | 2 | [NAME]
[NAME] | [NAME] | Quesadilla | Old School | OH | 495 | [NAME]
[NAME] | Blue | Burger | 1984 | PA | 4 | [NAME]
[NAME] | Red | Burger | 1984 | FL | 3 | [NAME]
[NAME] | Red | Burger | Catcher and the Rye | GA | 4 | [NAME]
[NAME] | Red | [NAME] | Old School | GA | 3 | George
[NAME] | Blue | Quesadilla | 1984 | OH | 2 | [NAME]
[NAME] | Green | Burger | 1984 | OH | 4 | George
[NAME] | Magenta | Burger | Catcher and the Rye | OH | 5 | [NAME]
Chip Evans | Aqua | Burger | Old School | OH | 53 | [NAME]
[NAME] | Blue | [NAME] | 1984 | NY | 2 | George
[NAME] | Red | Quesadilla | Catcher and the Rye | NJ | 4 | [NAME]
Spreadsheet: 858209d1706950491-looking-for-formula-to-create-number-series-creating-number-series_sample
Sheet: Here

Numbering | 11 |  |  | Creating number series
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: danny_mccarty__4651__KilmerBonusCommercial_UnP
Sheet: Commercial

 |  | LastName | First Name | Status | Division | Co Code | Supervisor | Org Unit | Job Code Description | Hire Date | Pay scale | Job Group | Annual Salary | 2000 YE Bonus | 2001 Bonus Range |  |  | Proposed | Supervisor | MD
Personnel No | GISID |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Medium | Low |  | Proposed | Adjusted | Final
504813 | 90008776 | Wilson | [NAME] | FRE | ETSCOMMEREXE | 62 | Kilmer III, [NAME] | ETS COMM Rates-Fgt | Mgr Rgnl Govt Affrs | 1998-09-21 00:00:00 | ML02 | Manager | 93164 | 10000 | 35000 | 15000 | 5000 | 15000 | 10000
505872 | 90006378 | Paschal | Zelda | FRN | ETSCOMMEREXE | 62 | Kilmer III, [NAME] | ETS COMM Rates-Fgt | [NAME] | 1997-03-03 00:00:00 | SAS3 | Senior Assistant | 41070 | 4200 | 4000 | 2500 | 500 | 2500 | 4000
505754 | 90008373 | Lichtenwalter | Bv | FRE | ETSCOMMEREXE | 62 | Lokey, [NAME] | ETS COMM Rates-Fgt | Analyst Rate/Reg SR | 1982-02-16 00:00:00 | CP17 | Senior Specialist | 78037 | 8500 | 17500 | 8500 | 2750 | 8500 | 9500
505720 | 90008372 | Thompson | [NAME] | FRE | ETSCOMMEREXE | 62 | Lokey, [NAME] | ETS COMM Rates-Fgt | Analyst Rate/Reg SR | 1975-06-05 00:00:00 | CP17 | Senior Specialist | 73684 | 12000 | 17500 | 8500 | 2750 | 8500 | 9500
507450 | 90012596 | [NAME] | Kelly | FRE | ETSCOMMEREXE | 62 | [NAME], Stephen | ETS COMM Rates-Fgt | Analyst Rate/Reg SR | 1988-09-19 00:00:00 | CP17 | Senior Specialist | 72000 | 13500 | 17500 | 8500 | 2750 | 8500 | 8500
505756 | 90008370 | Culwell | Christine | FRE | ETSCOMMEREXE | 62 | [NAME], Stephen | ETS COMM Rates-Fgt | Analyst Rate/Reg SR | 1973-06-06 00:00:00 | CP17 | Senior Specialist | 73646 | 8500 | 17500 | 8500 | 2750 | 8500 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pool $'s: | 51500
Spreadsheet: 742377d1627689096-if-statement-with-multiple-text-values-excel-help-sample-if-statement-2-
Sheet: Sheet1

Priority Criteria | 4 | X | 3 | X | 2 | X | 1 | X
Mission Criticality Tier | > 4 |  | 4 |  | 3 |  | 1 & 2 | X
End of Life / Regulatory Date | 12 + Months |  | 7 - 12 months |  | < 6 Months |  | Past End of Life/Support/Regulatory Date | X
Project Duration | 1 month or less |  | 2 - 3 months |  | 4 - 5 months |  | 6 + Months | X
Estimated IT Labor | <100 |  | 100-1000 |  | 1000-2000 |  | >2000
Dependent Projects |  |  |  |  | 1 |  | 2+ | X |  |  |  | <100 | 80
TOTALS |  | 0 |  | 0 |  | 0 |  | 12 |  |  |  | 101-1000 | 100
Overall Project Score | 12 |  |  |  |  |  |  |  |  |  |  | 1001-2000 | 200
 |  |  |  |  |  |  |  |  |  |  |  | >2000 | 50
1 = 3 points
2 = 2 points
1 = 1 point
0 = no points
Dependent projects only 3 options
2+ = 3 points
1 = 2 points
0 = 0 points
EOL date = base off TODAY and calendar days
 | Mission Criticality |  | End of Life /Regulatory Date |  | Project Duration |  | Estimated IT Labor (hours) |  | Dependent Projects
 | >4 |  | 2021-09-12 00:00:00 |  | 1 Month |  | 100 or less
 | 4 |  |  |  | 2-3 Months |  | 101-1000 |  | 0
 | 3 |  |  |  | 4-5 Months |  | 1001-2000 |  | 1
 | 2 |  |  |  | 6 Months Plus |  | 2000+ |  | >=2
 | 1
Spreadsheet: 789203d1658995735-sequence-and-iso-weeknumber-goes-over-week-53-criticalsalesplan_sample
Sheet: Projects

Project | Taak | Uitvoerende | Startdatum | Einddatum | Dagen gepasseerd | [NAME] | Target | Behaald
1. Rebook | Prebook | Sales Rep 1 | 2023-03-20 00:00:00 | 2023-03-27 00:00:00 | 2 |  | 100000 | 75000
1. Rebook | Rebook on-site | Sales Rep 1 | 2023-03-27 00:00:00 | 2023-03-31 00:00:00 | 1 |  | 200000 | 218000
1. Rebook | Orderverwerking | [NAME] | 2023-03-31 00:00:00 | 2023-04-05 00:00:00 | 3
1. Rebook | Rebooking overige deelnemers | Sales Rep 1 | 2023-04-05 00:00:00 | 2023-05-20 00:00:00 | 11 |  | 150000 | 140000
2. Sales Campaigns | Potential Mailing 1 vroegboek nabellen | Sales Rep 1 | 2023-04-10 00:00:00 | 2023-04-14 00:00:00 | 2 |  | 9000 | 0
2. Sales Campaigns | Potential Mailing 2 75% vol nabellen | Sales Rep 1 | 2023-08-10 00:00:00 | 2023-09-14 00:00:00 | 2 |  | 5000 | 0
2. Sales Campaigns | Potential Mailing 3 laatste plekken nabellen | [NAME] | 2023-10-10 00:00:00 | 2023-12-14 00:00:00 | 2 |  | 3000
Events | Concurrerend Event 1 bezoek nabellen | Sales Rep 1 | 2023-05-05 00:00:00 | 2023-05-19 00:00:00 | 2 |  | 7500 | 0
Events | Concurrerend Event 2 bezoek nabellen | Sales Rep 1 | 2023-09-05 00:00:00 | 2023-09-21 00:00:00 | 0 |  | 7500 | 0
Events | Concurrerend Event 3 bezoek nabellen | Sales Rep 1 | 2023-11-05 00:00:00 | 2023-11-20 00:00:00 | 0 |  | 7500 | 0
Content | Startersplein | [NAME] | 2023-01-20 00:00:00 | 2023-08-28 00:00:00 | 2 |  | 5000 | 6000
Content | Innovatiegalerij | [NAME] | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 1 |  | 15000 | 2000
Key Account | Account 1 | [NAME] | 2023-03-01 00:00:00 | 2023-03-02 00:00:00 | 1 |  | 10000 | 0 |  |  |  | Target | Gerealiseerd
Key Account | Account 2 | Sales Rep 1 | 2023-04-03 00:00:00 | 2023-04-04 00:00:00 | 1 |  | 15000 | 0 |  |  | bar chart | 582000 | 441000
Key Account | Account 3 | Sales Rep 1 | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 1 |  | 20000 | 0 |  |  | donut chart
Key Account | Account 4 | Sales Rep 1 | 2023-06-01 00:00:00 | 2023-06-02 00:00:00 | 1 |  | 15000 | 0
Key Account | Account 5 | [NAME] | 2023-09-01 00:00:00 | 2023-09-02 00:00:00 | 1 |  | 12500 | 0
Service Calls | Uitnodigingsservice | [NAME] | 2023-10-05 00:00:00 | 2023-10-16 00:00:00 | 2 |  | 0 | 0
Service Calls | Kick-off | [NAME] | 2023-11-15 00:00:00 | 2023-12-07 00:00:00 | 2 |  | 0 | 0
Spreadsheet: 831059d1685378985-trying-to-fill-dates-with-formula-andre-test-2-ans
Sheet: Sheet2

Name | Manager | Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x
[NAME] | [NAME] | 8am - 5pm |  | x | x | x | x | x
[NAME] | [NAME] | 8am - 5pm | x | x | x | x | x
Xavier | Rose | 8am - 5pm | x | x |  | x | x |  | x
Ziad | [NAME] | 9am - 6pm | x | x | x | x |  |  | x
Spreadsheet: 38460d1236626162-if-statement-help-test-specimen-accounting
Sheet: PATIENT INFORMATION

Name | Prefix | ID | DOB | Village | Spec 1 | Spec 2 | Spec 3
[NAME] | 9-N | 484 | 1990 | Kwatamang | PAP
TERESA | 9-SC | 298 | 1959 | Shulinab | HPV | PAP | BIOPSY
[NAME] | 9-SP | 8380 | 1952-02-06 00:00:00 | Paramakatoi | PAP | BIOPSY | HPV
CARRIE | 9-SP | 8234 | 1978-08-16 00:00:00 | Paramakatoi | BIOPSY
Spreadsheet: 823741d1680118271-conditional-format-above-or-below-budget-but-negative-numbers-cause-an-issue-sample-data
Sheet: Sheet1

0.1
 | DEALERSHIP SALES |  | ACTUAL | BUDGET
 | Vehicles |  | 1246976 | 631400
 | Service |  | 61301 | 81338
 | Parts |  | 66687 | 79647
 | TOTAL SALES |  | 1374964 | 792385
 | GROSS PROFIT
 | Vehicles |  | 85142 | 46966
 | Service |  | 44587 | 66341
 | Parts |  | 20202 | 18564
 | TOTAL GROSS PROFIT |  | 149931 | 131871
 | DIRECT PROFIT
 | Vehicles |  | 39490 | 5780
 | Service |  | 16216 | 23479
 | Parts |  | 10284 | 9744
 | TOTAL DIRECT PROFIT |  | 65990 | 39003
 | DOS/CSI Income |  | 0 | 0
 | Less Dealership Overheads |  | -55368 | -44850
 | DEALERSHIP NET PROFIT |  | 10622 | -5847
 | What I am trying to do is shown heere
 | https://youtu.be/4qfrZ7Eu-EY?t=264
Spreadsheet: 840762d1692969080-customers-list-with-variable-rows-for-each-customer-customers_sample
Sheet: Hárok1

 | CustomerID | Customer Name | Date | Services | Service cost | Total cost | Status | Notes
 | New Customer Row |  |  | New Service Row
 | A1 | [NAME] | 2023-05-06 00:00:00 | Service #1 | 20 |  | Completed & payment received
 |  |  |  | Service #2 | 30
 |  |  |  | Service #3 | 11.59
 |  |  |  | New Service Row
 | B23 | [NAME] | 2023-08-08 00:00:00 | Service #4 | 20 |  | Completed & awaiting Payment
 |  |  |  | Service #5 | 30
 |  |  |  | Service #6 | 40
 |  |  |  | Service #7 | 11.59
 |  |  |  | New Service Row
 | C13 | Random name | 2023-08-29 00:00:00 | Service #8 | 20 |  | Not Completed
 |  |  |  | Service #9 | 30
 |  |  |  | Service #10 | 40
 |  |  |  | Service #11 | 11.59
 |  |  |  | Service #12 | 20
 |  |  |  | New Service Row
Spreadsheet: 715128d1611580442-sum-on-a-pivot-table-column-with-multiple-criteria-match-person-between-two-dates-resource-planning-dashboard_help
Sheet: DB Main Pivot

DB Main Data Pivot
Team Member | Start Date | End Date | Sum of Allocation
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.35
 |  | 2021-05-31 00:00:00 | 0.04
 |  | 2021-06-01 00:00:00 | 0.5
 |  | 2021-06-12 00:00:00 | 0.04
 |  | 2021-07-01 00:00:00 | 0.04
 |  | 2022-05-22 00:00:00 | 1
[NAME] | 2021-01-25 00:00:00 | 2022-05-22 00:00:00 | 1
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.04
 |  | 2021-05-31 00:00:00 | 0.04
 |  | 2021-06-01 00:00:00 | 0.5
 |  | 2021-06-12 00:00:00 | 0.04
 |  | 2021-07-01 00:00:00 | 0.04
 |  | 2022-05-22 00:00:00 | 0.3
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.74
[NAME] | 2021-01-25 00:00:00 | 2021-05-31 00:00:00 | 0.35
 |  | 2021-07-01 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.35
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.04
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.04
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 0.08
 |  | 2022-05-22 00:00:00 | 1
Troy | 2021-01-25 00:00:00 | 2021-03-05 00:00:00 | 0.35
 |  | 2021-06-01 00:00:00 | 0.1
 |  | 2022-05-22 00:00:00 | 1
 |  | 2021-10-01 00:00:00 | 0.35
Unassigned | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.04
 |  | 2021-07-31 00:00:00 | 0.04
 |  | 2021-12-31 00:00:00 | 0.04
Ellen | 2021-01-25 00:00:00 | 2021-02-05 00:00:00 | 0.35
 |  | 2021-05-31 00:00:00 | 0.27
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-06-30 00:00:00 | 0.27
 |  | 2021-07-01 00:00:00 | 0.1
 |  | 2021-07-31 00:00:00 | 0.27
 |  | 2021-12-31 00:00:00 | 0.27
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.1
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.1
[NAME] | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.04
 |  | 2021-07-31 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.08
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.04
 |  | 2021-06-01 00:00:00 | 0.08
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.04
 |  | 2022-05-22 00:00:00 | 0.04
 |  | 2021-10-01 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-06-30 00:00:00 | 0.35
 |  | 2021-07-31 00:00:00 | 0.04
 |  | 2021-10-01 00:00:00 | 0.1
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.35
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
 |  | 2022-05-22 00:00:00 | 0.5
[NAME] | 2021-01-25 00:00:00 | 2021-06-01 00:00:00 | 1
 |  | 2022-05-22 00:00:00 | 0.1
[NAME] | 2021-01-25 00:00:00 | 2021-02-05 00:00:00 | 0.04
 |  | 2021-02-28 00:00:00 | 0.35
 |  | 2021-06-30 00:00:00 | 0.35
 |  | 2021-07-31 00:00:00 | 0.35
[NAME] | 2021-01-25 00:00:00 | 2021-02-28 00:00:00 | 0.35
 |  | 2021-05-31 00:00:00 | 0.35
 |  | 2021-06-12 00:00:00 | 0.35
 |  | 2021-07-01 00:00:00 | 0.35
 |  | 2021-12-31 00:00:00 | 0.35
 | 2021-01-29 00:00:00 | 2021-06-29 00:00:00 | 0.04
 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 0.04
Spreadsheet: 682417d1592078066-can-i-collor-one-week-2-cells-and-other-week-3-with-conditional-formating-voorwaardelijk-opmaak-probleem
Sheet: Datablad

2020
Datum | [NAME] | dag maan | brugdag |  |  | Soort te werkstelling |  |  | [NAME] | Ziek aantal |  | [NAME] | Werkongeval aantal
 | Nieuwjaar |  |  |  |  | Voltijds
 | Paaszondag |  |  |  |  | 4/5
 | Paasmaandag |  |  |  |  | Halftijds
 | Dag v/d Arbeid
 | Hemelvaartsdag
 | Pinksterzondag |  |  |  |  | Welke Dag 4/5
 | Pinkstermaandag |  |  |  |  | Maandag
 | Nationale Feestdag |  |  |  |  | Dinsdag
 | [NAME] |  |  |  |  | Woensdag
 | Allerheiligen |  |  |  |  | Donderdag
 | Wapenstilstand 1918 |  |  |  |  | Vrijdag
 | Kerstmis
 | 2de Kerstdag
tot aantal feestdagen in weekend
Codes | Naam | Aantal Dagen
KD | [NAME]
[NAME] VM | [NAME] voormiddag
KD NM | [NAME] namiddag
[NAME] | Collectief verlof | 1
[NAME] | Collectief [NAME]
[NAME] | Collectief [NAME]
V | Verlof
V VM | Verlof voormiddag
V NM | Verlof namiddag
Z | Ziek | -1
ZoW VN | Ziek geworden op werk voormiddag
ZoW NM | Ziek geworden op werk namiddag
SP | Sociale promotie
GV | Gelegenheidsverlof
GV VM | Gelegenheidsverlof voormiddag
GV NM | Gelegenheidsverlof namiddag
VN | Dienstvrijstelling
VN VM | Dienstvrijstelling voormiddag
VN NM | Dienstvrijstelling namiddag
ZD | Zending
ZD VM | Zending voormiddag
ZD NM | Zending namiddag
WO | Werkongeval
STAKING | Staking
VVJ | Verlof vorig jaar | 5
VVJV | Verlof vorig [NAME]
VVJM | Verlof vorig jaar namiddag
OBTVERLOF | [NAME] verlof
4/5 | 4/5
Spreadsheet: 769140d1645346306-sperating-single-cell-day-date-time-multiple-cells-seeking-help-breaking-down-date-time-cells
Sheet: Sheet1

Date | Day | Month | Date | Time
Fri 14 Mar 7:50pm
Sat 15 Mar 4:40pm
Sat 15 Mar 6:40pm
Sun 16 Mar 7:40pm
Thu 20 Mar 7:10pm
Fri 21 Mar 7:50pm
Sat 22 Mar 4:40pm
Sat 22 Mar 7:40pm
Sun 23 Mar 4:40pm
Spreadsheet: 40997d1239391477-between-two-numbers-betweentwonumbers
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65356104 | 0.02468692136238721 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6239191 | 0.06803221763847268 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5066625 | 0.0472957836824316 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4555344 | 0.03573078125384165 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2533802 | 0.02401055804676135 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2797487 | 0.02328840134020283 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2964260 | 0.03702542961818464 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2875823 | 0.03787367998656384 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2180858 | 0.01917272926527083 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1093849 | 0.005174388786752102 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 191007 | 0 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95854350
Spreadsheet: 223257d1364134113-how-can-i-get-revenue-from-this-cost-benefit-analysis
Sheet: Sheet1

Cost/Benefit Analysis
Operational Cost Elements: | Initial Costs | 2013-2014 | 2014-2015 | 2015-2016 | 2016-2017 | 2017-2018 | 2018-2019 | 2019-2020 | Total
A. External Service Provider - Operational Costs:
Inflation Rate |  | 0.027 | 0.102 | 0.069 | 0.024 | 0.048 | 0.797 | 0.306
Number of Years |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Network/Hosting Services (Per Month) | 3.95
Maintenace & Support Services (Per Month) | 2.65
Data Communications Services | 10
Total Per Year (Inflation Rate included)
Total Per Year (Without Inflation Rate)
B. Design Team - Operational Costs:
Inflation Rate |  | 0.027 | 0.102 | 0.069 | 0.024 | 0.048 | 0.797 | 0.306
Number of Years |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Maintenace (Per 6 Months) | 1000
Prototype Cost (Per year) | 2500 | 0 |  | 0 |  | 0 |  | 0
Design Implementation | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Per Year (Inflation Rate included)
Total Per Year (Without Inflation Rate)
C. Data Processing: - Operational Costs:
Inflation Rate |  | 0.027 | 0.102 | 0.069 | 0.024 | 0.048 | 0.797 | 0.306
Number of Years |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Hardware (Computers to run website on etc) | 20000 | 0 | 0 | 20000 | 0 | 0 | 20000 | 0
Software (IDE for website development etc) | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Total Per Year (Inflation Rate included)
Total Per Year (Without Inflation Rate)
D. Personnel - Operational Costs:
Inflation Rate |  | 0.027 | 0.102 | 0.069 | 0.024 | 0.048 | 0.797 | 0.306
Number of Years |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Employee Salery (Per Month) | 1500
Total Per Year (Inflation Rate included)
Total Per Year (Without Inflation Rate)
E. Others - Operational Costs:
Inflation Rate |  | 0.027 | 0.102 | 0.069 | 0.024 | 0.048 | 0.797 | 0.306
Number of Years |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Copyright (Per 6 Months) | 39
Training | 3000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000
Total Per Year (Inflation Rate included)
Total Per Year (Without Inflation Rate)
Subtotal of Operational Costs (Without Inflation)
Subtotal of Operational Costs (With Inflation)
Revenue
Total Changes in Operational Costs
Spreadsheet: 696872d1601020700-sumproduct-with-indirect-mainsheet
Sheet: 1.AA

Particulars | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | FY-20 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | FY-21
Production Qty | 100
Production Cost
Material Cost
Fuel Cost
Power Cost | 20
Spreadsheet: 74413d1274929211-show-row-of-data-from-a-selection-in-a-list-box-project-data-with-combo-box
Sheet: B

Project ID | Project Name | Start Date | End Date |  |  | List Value
p00001 | Project Name 1 | 2010-06-07 00:00:00 | 2010-09-07 00:00:00 |  |  | 7
p00002 | Project Name 2 | 2010-06-17 00:00:00 | 2010-09-17 00:00:00
p00003 | Project Name 3 | 2010-05-31 00:00:00 | 2010-09-06 00:00:00
p00004 | Project Name 4 | 2010-06-11 00:00:00 | 2010-09-15 00:00:00
p00005 | Project Name 5 | 2010-06-09 00:00:00 | 2010-09-02 00:00:00
p00006 | Project Name 6 | 2010-06-01 00:00:00 | 2010-08-25 00:00:00
p00007 | Project Name 7 | 2010-06-16 00:00:00 | 2010-09-12 00:00:00
p00008 | Project Name 8 | 2010-06-08 00:00:00 | 2010-08-27 00:00:00
p00009 | Project Name 9 | 2010-06-17 00:00:00 | 2010-09-01 00:00:00
p00010 | Project Name 10 | 2010-06-23 00:00:00 | 2010-09-04 00:00:00
Spreadsheet: 95431d1295020787-excel-2007-automatically-update-master-sheet-with-information-from-other-sheets-practice-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  | FMC RATE | %
AIRCRAFT | STATUS | LAST FLY | BOT | ETIC | P+ | WUC | NARRATIVE | MON | TUE | WED | THU | FRI | SAT | SUN
[NAME] | POSSESION | DAYS DOWN |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
99-0001 | FMC
ALASKA | CC
99-0002 | FMC
ALASKA | CC
99-0003 | FMC
ALASKA | CC
99-0004 | FMC
ALASKA | CC
99-0005 | FMC
ALASKA | CC
99-0006 | FMC
ALASKA | CC
99-0007 | FMC
ALASKA | CC
99-0008 | FMC
ALASKA | CC
99-0009 | FMC
ALASKA | CC
99-0010 | FMC
ALASKA | CC
99-0011 | FMC
ALASKA | CC
99-0012 | FMC
ALASKA | CC
99-0013 | FMC
ALASKA | CC
99-0014 | FMC
ALASKA | CC
99-0015 | FMC
ALASKA | CC
99-0016 | FMC
ALASKA | CC
99-0017 | FMC
ALASKA | CC
99-0018 | FMC
ALASKA | CC
99-0019 | FMC
ALASKA | CC
99-0020 | FMC
ALASKA | CC
99-0021 | FMC
ALASKA | CC