tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 688728d1595929059-alternative-way-to-make-this-lighter-faster-opb-format-sample-2
Sheet: Legend

 | Level | Description | Unit
 | 1 | Project Name | Lot
 | 2 | Contract | Lot
 | 3 | Floor | Lot
 | 4 | Zone / Unit | Lot
 | 5 | Work Category | Lot
 | 6 | Sub Category | Unit
 | 7 | BOQ Main Item / Structure | Unit
 | 8 | BOQ Sub Item / OPB | Unit
 |  | Mat
 |  | Lab
 |  | Log
 |  | Eqp
Spreadsheet: 177927d1346523042-how-to-add-multiple-axis-in-the-chart-c-vs-p-as-on-31-08-12
Sheet: Sheet1

 | CATEGORYWISE PAYMENT MADE AS ON 31.08.12
 | Year | Capital |  | Chemical |  | Project |  | Service |  | Spares & Consumables |  | Welfare & Safety |  | Total
 |  | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME].
 | 2009 | 1.51416701008018 |  | 0.706943376 |  | 2.41260505 |  | 0.381588006965636 |  |  |  | 0.473799897563001
 | 2010 | 2.95847281855556 |  | 0 |  | 4.417454596611109 |  | 1.84582919902222 |  |  |  | 0.9167277014444449
 | 2011 | 5.18706724511111 |  | 0.23882665 |  | 2.33583847138889 |  | 2.90319622978889 |  | 18.1561552169483 |  | 0.7940700980222221
 | 2012 | 3.23756011345833 |  | 0.244358961111111 |  | 0.20881862 |  | 1.32683107076778 |  |  |  | 0.511045799255556
 | Total
Spreadsheet: 10c31411-3711-4554-9043-a8e5b85c274c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | Bkgd | 0.3539
 |  |  |  |  |  | Mock | 2.236
 |  |  |  |  | Caspase 3 | 0,01U | 2.836
 |  |  |  |  | Caspase 3 | 0,1U | 102.5
 |  |  |  |  | Caspase 3 | 1,0U | 224.3
Spreadsheet: 676810d1588982307-sumproduct-with-embedded-if-sumproduct-with-if
Sheet: Combined

 |  | SUMMARY |  |  |  |  |  |  |  |  |  | SOURCE DATA
 |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 |  | Q1 2020 |  |  |  |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020
 |  | Begin | Transfer | Cont | Dist |  | End |  |  |  |  | Begin | Transfer | Transfer | Transfer | Cont | Dist | End
 |  | Begin | * | Cash | Cash |  | End |  |  |  |  | Begin | Balance | Item 1 | Item 3 | Cash | Cash | End
 |  |  | Net Transfer |  |  |  |  |  |  |  |  |  | TRANSFERS
 | ID | Beginning | Transfer | Cont | Dist |  | Ending | Expected | Difference |  | ID | Beginning | Balance | Item 1 | Item 3 | Cont | Dist | Ending
With embedded IF | 822 |  |  |  |  |  |  |  |  |  | 822 | 5000000 | 100000 | 0 | -5000 | 500000 | -500000
With embedded IF | 822
Only SUMPRODUCT | 822 |  |  |  |  |  |  |  |  |  | 825 | 6000000 | 0 | 157174.61 | 0 | 600000 | -400000
Expected | 822 |  |  |  |  |  |  |  |  |  | 831 | 7000000 | 314349.22 | 0 | 0 | 700000 | -300000
 |  |  |  |  |  |  |  |  |  |  | 1003 | 8000000 | 0 | 0 | 5000 | 800000 | -200000
TEST GROUP
 | 822
 | 825
 | 831
 | 1003
Spreadsheet: 876487d1723184208-iferror-help-blank-training-tracker_2024
Sheet: Control

 | New Year's Day
 | [NAME] Birthday
 | Inauguration Day
 | Presidents' Day
 | Memorial Day
 | Juneteenth
 | Independence Day
 | Labor Day
 | Columbus Day
 | Presidential Election Day
 | Veterans Day
 | Thanksgiving Day
 | Christmas Day
Spreadsheet: 840785d1692980556-sum-up-columns-based-on-specific-dates-test
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  |  | 2023-08-01 00:00:00 | 2023-08-24 00:00:00
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 08:45:00 | 1.000000000116415 |  |  | Total downtime
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73641 | 2022-05-23 15:35:29 | 2022-05-23 16:35:54 | 1.006944444437977
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 | 2023-08-25 00:00:00 | 10708.77714444447
VL1
Spreadsheet: 44400d1243002196-excel-2007-pivot-count-refers-to-cells-with-formulas-sample-pivot-ignore-count-blanks
Sheet: Data

Item | [NAME] | Condition 1 | Condition 2 | Condition 3
A |  | Yes | No | No
B |  | Yes | No | No
C |  | No | Yes | No
D |  | No | Yes | No
E |  | No | No | Yes
F |  | No | No | Yes
G |  | No | No | No
H |  | No | No | No
Spreadsheet: 121518d1316106574-consolidation-issue-excel001
Sheet: Sheet1

A13D | 1
2.166666666666667 | #[NAME]! | 0.25 | #[NAME]! | 2.5 | 0 | 0 | 0 | 0 |  |  | A13D |  |  |  |  |  | #[NAME]! | 0 | 0
A13D |  | 3
4.5 | #[NAME]! | 1.5 | #[NAME]! | 0 | 0 | 0 | 0 | 0 |  |  | T42D |  |  |  |  |  | 0 | 0 | 0
A13D |  |  |  | 5
 |  |  |  |  | 0 | 0 | 0 | 0
L149N | 2
L149N |  |  | 6
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
T42D | 4
 |  |  |  |  | 0 | 0 | 0 | 0
T42D |  |  |  | 8
 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0
A13D | 1 | 3 |  | 5
L149N | 2 |  | 6
T42D | 4 |  |  | 8
Spreadsheet: 140066d1328615129-problem-with-colouring-the-entire-row-based-on-odd-or-even-number-in-the-first-cell-ef28_example
Sheet: SL

 |  |  |  |  |  |  |  | Vendor
No | Target lg | Source lg | To foreign Y/N | Interpreter | Sworn/certified translator | Escaepe | Gender | Surname | Name | Contract signed with .. | Status | Vendor pool | Type of service | Unavailability
1 | sl |  |  |  |  |  | Mr | Surname 1 | Name 1 |  | Rejected
2 | sl | DE |  |  |  | Y | Mr | Surname 2 | Name 2 |  | Active | sub_eude_eulu_eusw_eupl_vm_pool | C: T
2 | sl | EN |  |  |  | Y | Mr | Surname 2 | Name 2 |  | Active | sub_eude_eulu_eusw_eupl_vm_pool | C: T
3 | sl | FR |  |  |  | Y | Mr | Surname 3 | Name 3 |  | Active | sub_eude_eulu_eusw_eupl_vm_pool | C: T
4 | hr | SL |  |  | x | Y | Mr | Surname 4 | Name 4 |  | Inactive | sub_eude_vm_pool  Prod | FR: T
4 | sl | EN |  |  | x | Y | Mr | Surname 4 | Name 4 |  | Under evaluation | sub_eulu_vm_pool | FR: T
5 | sl |  |  |  |  |  | Ms | Surname 5 | Name 5 |  | Rejected
6 | sl |  |  |  |  | Y |  | Surname 6 | Name 6
6 | sl | DE |  |  |  | Y | Mr | Surname 6 | Name 6 |  | Active | sub_euhu_vm_pool | FR: T/R
6 | sl | EN |  |  |  | Y | Mr | Surname 6 | Name 6 |  | Active | sub_euhu_vm_pool | FR: T/R
7 | sl | HR |  |  |  | Y | Mr | Surname 7 | Name 7 |  | Active | sub_euhu_vm_pool | FR: T/R
 |  |  |  |  |  |  |  | Problem with colouring the entire row based on odd or even number in the first cell.
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 26

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-26 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1084 |  | 997 |  | 67694 |  |  |  |  |  | 15 | 1 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 2 | 18
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 13686 |  | 13043 |  | 67694 |  |  |  |  |  | 16 | 3 | 18 |  |  | 15
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0 |  |  |  |  | 16 | 4 | 15 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 5 | 18 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 6082 |  | 5678 |  | 67694 |  |  |  |  |  | 16 | 6 | 17 |  |  | 22
 |  |  |  |  |  |  |  |  | 411 |  | 411 |  | 69148 | 0 |  |  |  |  | 15 | 7 | 17 |  |  | 15
 |  |  |  |  |  |  |  |  | 147 |  | 147 |  | 68915 | 0 |  |  |  |  | 18 | 8 | 19 |  |  | 14
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 17 | 9 | 17 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 15 | 24 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 22275 |  | 20970 |  | 67694 |  |  |  |  |  | 18 | 35 | 17 |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 | 0 |  |  |  |  | 16 | 39 | 15 |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2553 |  | 2352 |  | 67694 | 1 |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 3235 |  | 3313 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68916 | 0
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 19765 |  | 19765 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3185 |  | 3079 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3947 |  | 3832 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4957 |  | 4957 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1602 |  | 1680 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 56 |  | 57 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 869494d1716049751-how-to-filter-a-column-based-on-a-column-in-a-different-file-all-comptuers2-ghurty-
Sheet: Report (31)

Name | GuestLastBootTime | GuestMachineSerialNumber | CustomProperty1 | Filter
LAB1-7 | 2024-04-08 20:17:59 | 2993PD2 | ACME
LAB1-4 | 2023-12-19 21:28:02 | J4BDF42 | ACME
LAB1-12 | 2024-04-24 04:42:08 | 3FRQX14 | ACME
LAB009 | 2022-09-13 16:51:59 | JLSRX14 | ACME
LAB1-31 | 2024-02-07 20:24:27 | 313RX14 | ACME
LAB1-28 | 2024-04-08 16:05:38 | 963RX14 | ACME
LAB1-23 | 2023-03-14 19:00:03 | J49CF42 | ACME
LAB1-8 | 2022-11-24 21:19:03 | 2594PD2 | ACME
LAB1-22 | 2024-04-02 18:58:53 | J49FF42 | ACME
Spreadsheet: 681465d1591595380-count-unique-values-for-a-specific-date-example-data-caracalla-code-by-keebellah-
Sheet: Sheet1

Date | Invoice |  |  |  | Date | Unique Orders |  | Problem Formula |  | Invoice
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-21 00:00:00 |  |  |  |  | 15567
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-22 00:00:00 |  |  |  |  | 55978
2020-02-21 00:00:00 | 15567 |  |  |  | 2020-02-23 00:00:00 |  |  |  |  | 35013
2020-02-21 00:00:00 | 55978 |  |  |  | 2020-02-24 00:00:00 |  |  |  |  | 67922
2020-02-21 00:00:00 | 35013 |  |  |  | 2020-02-25 00:00:00 |  |  |  |  | 15620
2020-02-21 00:00:00 | 67922 |  |  |  |  |  |  |  |  | 73486
2020-02-22 00:00:00 | 15620 |  |  |  |  |  |  |  |  | 17106
2020-02-23 00:00:00 | 73486 |  |  |  |  |  |  |  |  | 97625
2020-02-23 00:00:00 | 17106 |  |  |  |  |  |  |  |  | 8452
2020-02-24 00:00:00 | 97625 |  |  |  |  |  |  |  |  | 15747
2020-02-24 00:00:00 | 97625 |  |  |  |  |  |  |  |  | 15808
2020-02-24 00:00:00 | 8452 |  |  |  |  |  |  |  |  | 15767
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 68733
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 15801
2020-02-24 00:00:00 | 15747 |  |  |  |  |  |  |  |  | 15813
2020-02-25 00:00:00 | 15808
2020-02-25 00:00:00 | 15767
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 68733
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15801
2020-02-25 00:00:00 | 15813
Spreadsheet: 0a0fbe0a-6c9f-47e7-9fa4-ebc6d91b3cf0
Sheet: Out-State Travel

OUT-OF-STATE TRAVEL
* Note: Total cost (see equation) does not include the amount for Registration Fee
Registration Fee can be included in training budget
Employee Name | Travel Purpose | Beginning Dates | Ending Dates | Mileage | Mileage Rate | Airfare | Lodging | Meals | [NAME] | % Allocated to CACFP | Total Annual Cost
 |  | 2011-09-18 00:00:00 | 2011-09-22 00:00:00 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0.5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Total OUT-STATE Travel
Spreadsheet: 882405d1730800958-index-for-multiple-criteria-with-multiple-result-sample
Sheet: Sheet1

RANGE | Within 12 months
SEARCH SPOT 1
Branch Code | 62740
Branch Name
Result_SPOT 1
Finding | Manager | Executiive | AA No. | Name of Borrower | Property Location (residential area, town) | Agency Name
[NAME]
[NAME]
[NAME]
Spreadsheet: 758687d1639001380-football-want-to-compare-stats-from-one-formation-to-another-book1
Sheet: Sheet1

 |  |  |  | Formation | F | A | Results | Against | Opp. Formation |  |  | Formation 1 |  |  | Formation 2
 |  |  |  | 4-1-2-1-2 | 3 | 0 | Win | 3rd | 4-2-3-1 |  |  | W | L |  | W | L
 |  |  |  | 4-1-2-1-2 | 2 | 2 | Draw | 18th | 4-3-3
 |  |  |  | 4-1-2-1-2 | 0 | 2 | Loss | 11th | 4-2-3-1 |  |  | F | A |  | F | A
 |  |  |  | 4-2-3-1 | 3 | 1 | Win | 12th | 4-4-2
 |  |  |  | 4-2-3-1 | 4 | 0 | Win | 11th | 4-4-2
 |  |  |  | 4-2-3-1 | 3 | 0 | Win | 2nd | 4-2-3-1
 |  |  |  | 4-2-3-1 | 1 | 0 | Win | 15th | 4-2-3-1
 |  |  |  | 4-2-3-1 | 2 | 0 | Win | 17th | 4-2-3-1
 |  |  |  | 4-2-3-1 | 0 | 0 | Draw | 10th | 4-3-3
 |  |  |  | 4-2-3-1 | 4 | 1 | Win | 8th | 4-4-2
 |  |  |  | 4-2-3-1 | 2 | 0 | Win | 6th | 4-2-3-1
Spreadsheet: 2b5e851d-bab7-4516-aa59-61a0ca55ac60
Sheet: Sheet1

Unnamed: 0 | 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
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: PARRAMATTA
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1300 301 994 before 9am Monday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 745 Springvale Road, MULGRAVE VIC 3170
August 2010
Spreadsheet: 163309d1340273970-count-simlilar-values-test1
Sheet: Sheet1

Detailed |  |  |  |  |  |  | Summary
 |  |  |  | Driver |  |  | Name | Counts
 |  |  |  | [NAME] |  |  | [NAME] |  |  | Click on cell I3 and look in the formula bar.
 |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | [NAME] |  |  | IBRAHIM
 |  |  |  | Lara
 |  |  |  | Rodlpho
 |  |  |  | Snezana
 |  |  |  | Serguei
 |  |  |  | GENIS
 |  |  |  | GENIS
 |  |  |  | IBRAHIM
 |  |  |  | IBRAHIM
 |  |  |  | IBRAHIM
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Serguei
 |  |  |  | GENIS
 |  |  |  | Vijay
 |  |  |  | Vijay
 |  |  |  | [NAME]
 |  |  |  | Snezana
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: david_delainey__8076__Pro Forma P & L
Sheet: pro-forma year 1-3

On-Site Power Generation Reclamation
Pro Forma P & L Statement
 |  | Year 1 |  | Year 2 | Year 3
[NAME] |  |  |  |  |  |  | 100
Target Contracted Electrical Power (MW) |  | 100 |  | 200 | 300
Estimated Percentage of Target Volume
Actual Contracted Electrical Power (MW)
Sales
Spot Market Sell-off Rates / Periods in given year: |  |  |  |  |  |  | 100
Hours above spot price:
Spot price ($/MWh):
Hours above spot price: |  |  |  |  |  | (Hours) |  | (Price)
Spot price ($/MWh):
Total Revenue |  |  |  |  |  |  | 100
Cost of Sales
Misc. Variable Costs: |  |  |  |  |  |  | 100
Energy Monitor/Controls installation
Hardware per 1 MW:
Labor per 1 MW: |  |  |  |  |  | (COS)
Power [NAME] vendor [NAME]
Annual Rebate per 1 MW:
Customer Rebate
Annual Rebate per 1 MW:
Total COS
Gross Profit
Expenses
[NAME] and Wages (Burdened)
Director |  | 300000 |  | 350000 | 400000
Outside Sales Support |  | 0 |  | 200000 | 400000
Inside Sales Support |  | 200000 |  | 200000 | 300000
Administrative Support |  | 100000 |  | 100000 | 100000
Transportation
Company Car |  | 10000 |  | 20000 | 30000
Travel |  | 100000 |  | 150000 | 200000
General Administration
IT Support/Software/Web |  | 200000 |  | 100000 | 100000
Advertising |  | 30000 |  | 30000 | 30000
Phones |  | 10000 |  | 20000 | 25000
PC's (hardware) |  | 6000 |  | 9000 | 12000
General Supplies |  | 10000 |  | 15000 | 20000
Facility/Support |  | 50000 |  | 60000 | 70000
Operating Expenses
PBIT
Total Cost per MW-hr:
Break Even Point (BEP) in MW at 100% est. costs: |  | 71 |  | 88 | 118
Spreadsheet: 796027d1663073222-google-sheets-countifs-until-a-sumif-condition-is-met-question-1-
Sheet: Sheet1

 | Initial Stock | 100
 | Sales forecast | 10
 | Stock Last upto
 | Given Date | 2022-09-15 00:00:00
 | No of Days
Spreadsheet: 105253d1302683560-normalising-data-normalising
Sheet: Sheet1

 | Set 1 Results (250 people) | Set 2 Results (80 people)
Jan | 4985 | 1959
Feb | 4593 | 1415
Mar | 5146 | 2184
Apr | 4582 | 2203
May | 5066 | 1659
Jun | 6169 | 5521
Jul | 7769 | 3952
Aug | 6131 | 4214
Sep | 7415 | 3919
Oct | 4538 | 1921
Nov | 4959 | 1846
Dec | 5142 | 1892
Spreadsheet: 26932d1219660058-lookup-function-driver-login
Sheet: 6.23.08

 |  |  |  | Trailer Type
 | Pick-up # | Destination | Customer | Van | Flat | PIG | Trucking Co. | Appointment Time | Time In | Time Out
1 |  |  |  |  |  |  |  | 7:30 A.M.
2 |  |  |  |  |  |  |  | [NAME]
3 |  |  |  |  |  |  |  | 8:30 A.M.
 |  |  |  |  |  |  | BREAK | 9:15 A.M.
4 | 64819 | Detroit,Mich | Mtsavage |  | x |  | M&C | 9:30 A.M.
5 |  |  |  |  |  |  |  | 10:00 A.M.
6 |  |  |  |  |  |  |  | 10:30 A.M.
 |  |  |  |  |  |  | LUNCH | 11:00 A.M
7 |  |  |  |  |  |  |  | 11:30 A.M.
8 |  |  |  |  |  |  |  | 12:00 P.M.
9 |  |  |  |  |  |  |  | 12:30 P.M.
10 |  |  |  |  |  |  |  | 1:00 P.M.
 |  |  |  |  |  |  | BREAK | 1:30 P.M.
11 |  |  |  |  |  |  |  | 1:45 P.M.
12 |  |  |  |  |  |  |  | 2:15 P.M.
13 |  |  |  |  |  |  |  | 2:45 P.M.
14 |  |  |  |  |  |  |  | 3:15 P.M.
15 |  |  |  |  |  |  |  | 3:45 P.M.
16 |  |  |  |  |  |  |  | 4:15 P.M.
17 |  |  |  |  |  |  |  | 4:45 P.M.
 |  |  |  |  |  |  | BREAK | 5:30 P.M.
18 |  |  |  |  |  |  |  | 5:45 P.M.
19 |  |  |  |  |  |  |  | 6:15 P.M.
20 |  |  |  |  |  |  |  | 7:00 P.M.
 |  |  |  |  |  |  | LUNCH | 7:30 P.M.
21 |  |  |  |  |  |  |  | 8:00 P.M.
22 |  |  |  |  |  |  |  | 8:30 P.M.
 |  |  |  |  |  |  | BREAK | 9:30 P.M.
23 |  |  |  |  |  |  |  | 9:45 P.M.
24 |  |  |  |  |  |  |  | 10:45 P.M.
25 |  |  |  |  |  |  |  | 11:45 P.M.
26 |  |  |  |  |  |  |  | 12:45 A.M.
Spreadsheet: 103576d1301336189-countif-from-a-drop-down-list-into-pie-chart-example
Sheet: Sheet1

Patient no. | Last name | first name | result | graph data | 6
1 | doe | [NAME] | abnormal | 1
2 | doe | [NAME] | mutated | 1
3 | doe | [NAME] | normal | 1
4 | doe | [NAME] | abnormal | 1
5 | doe | [NAME] | mutated | 1
6 | doe | [NAME] | mutated | 1
Spreadsheet: 882162d1730406313-dynamic-drop-down-using-tables-henighanhome-copy
Sheet: Lists

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rng_CostType
 | lst_Status |  | lst_PricingType |  | lst_ChargingApproach |  | rng_LabourRate |  |  |  | Paid |  | lst_InvoiceSelector |  | lst_CostType | lst_CostDetail |  | Prep Table |  | DropDownSample | Filter Sample |  | rng_InvoicePaymentTarget |  |  | rng_Margin |  |  | dd_OpenJobs |  | dd_Tasks
 | Planned |  | Estimate |  | Hourly |  | Date | Hourly | Daily |  | Part |  |  |  | Aggregates | Sand - Building |  |  |  | Electrics |  |  | 0 | Ok |  | date | margin
 | Ongoing |  | Quote |  | Daily |  | 2024-09-02 00:00:00 | 20 | 250 |  | Full |  |  |  | Aggregates | Cement |  | Timber |  |  | Fixings |  | 10 | Chase 1 |  | 2024-09-01 00:00:00 | 1.05 |  |  |  | Raised Beds
 | Completed |  |  |  | Fixed |  | 2025-03-01 00:00:00 | 30 | 350 |  | Not Paid |  |  |  | Aggregates | Sand - Sharp |  | Roofing |  |  | Consumer Units |  | 20 | Chase 2 |  | 2024-10-31 00:00:00 | 1.1 |  |  |  | Poly Tunnel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aggregates | Post Mix |  | Electrics |  |  | Commissioning |  | 30 | Overdue |  |  |  |  |  |  | Fence Panel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aggregates | Scalpings |  | Flooring
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Planed |  | Windows
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Tanalised |  | Doors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Timber | Natural |  | Insulation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Tiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Felt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing | Corrugate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Cables
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Fixings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Consumer Units
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrics | Commissioning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Floorboards
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Tiles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Carpet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Lino
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flooring | Substrate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Frame
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Fixings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | Locks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Windows | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doors | Internal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doors | External
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insulation | Board
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insulation | Fibre
Spreadsheet: 45283d1244051333-percentile-percentile
Sheet: Sheet1

Grade | Amount
B2 | 3 |  | VLOOKUP Table
B2 | 2 |  | B2 | 8
B3 | 5 |  | B3 | 18
B3 | 6 |  | B4 | 17
B4 | 8 |  | B5 | 21
B4 | 9 |  | B6 | 29
B5 | 10
B5 | 11
B6 | 15
B2 | 3
B3 | 7
B6 | 14
Need function for the table below
Percentile | 0.1 | 0.25 | 0.5 | 0.6 | 0.75 | 0.9
B2 | 0.8 | 2 | 4 | 4.8 | 6 | 7.2
B3 | 1.8 | 4.5 | 9 | 10.8 | 13.5 | 16.2
B4 | 1.7 | 4.25 | 8.5 | 10.2 | 12.75 | 15.3
B5 | 2.1 | 5.25 | 10.5 | 12.6 | 15.75 | 18.9
Spreadsheet: 191288d1352045980-multiple-look-up-to-return-multiple-values-book1
Sheet: Sheet

Date | Cntrl #'s | a | b | c | d |  | Unit | [NAME] | Amount | Date
2011-10-03 00:00:00 | 159,145,1042,885,102 |  |  |  |  |  | a | 159 | 50000 | 2011-10-03 00:00:00
2011-10-04 00:00:00 |  |  |  |  |  |  | b | 1150 | -40160 | 2011-10-03 00:00:00
2011-10-05 00:00:00 |  |  |  |  |  |  | c | 382 | 50000 | 2011-10-04 00:00:00
2011-10-06 00:00:00 |  |  |  |  |  |  | d | 1435 | -30212 | 2011-10-05 00:00:00
2011-10-07 00:00:00 |  |  |  |  |  |  | e | 221 | 20000 | 2011-10-03 00:00:00 | Not in UsedItems so not added
2011-10-08 00:00:00 |  |  |  |  |  |  | a | 1250 | -17600 | 2011-10-07 00:00:00
2011-10-09 00:00:00 |  |  |  |  |  |  | b | 145 | 32159 | 2011-10-03 00:00:00
2011-10-10 00:00:00 |  |  |  |  |  |  | c | 1042 | -23000 | 2011-10-03 00:00:00
2011-10-11 00:00:00 |  |  |  |  |  |  | d | 1222 | -3319 | 2011-10-04 00:00:00
2011-10-12 00:00:00 |  |  |  |  |  |  | e | 294 | 50000 | 2011-10-05 00:00:00
2011-10-13 00:00:00 |  |  |  |  |  |  | a | 1143 | -48506 | 2011-10-06 00:00:00
 |  |  |  |  |  |  | b | 538 | 48506 | 2011-10-07 00:00:00
 |  |  |  |  |  |  | c | 885 | 228000 | 2011-10-03 00:00:00
 |  |  |  |  |  |  | d | 1012 | 30000 | 2011-10-03 00:00:00
 |  |  |  |  |  |  | e | 1594 | -35646 | 2011-10-04 00:00:00
 |  |  |  |  |  |  | a | 220 | 20000 | 2011-10-05 00:00:00
 |  |  |  |  |  |  | b | 1306 | -18404 | 2011-10-06 00:00:00
 |  |  |  |  |  |  | c | 151 | 200000 | 2011-10-07 00:00:00
 |  |  |  |  |  |  | d | 1041 | -200000 | 2011-10-13 00:00:00