tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 584718d1533339970-excel-filling-one-table-with-data-from-another-table-copy-of-d-ploiements-clients-erex-
Sheet: Data - X

Nom du client | [NAME] | Client Existant | Commercial | Revendeur | Adresse | Ville | Fournisseur | Type d'accès | Débit | NB de paires | Zone Tarifaire | [NAME] | [NAME] | Type Modem | [NAME] | Ariane | IP Publique dédiée | Nb Ip publiques | Adresse [NAME] | Facturation Equipements | Audit | Date Audit | Resultat Audit | Facturation Audit | Date commande | Référence Fournisseur | Date [NAME] | Numéro de suivi transporteur | [NAME] | Coût port | Date [NAME] | RDV Installation | Date convenue | Date effective  [NAME] | Date [NAME] | [NAME]
Client 1 | En cours | NON | ID | ADER | 9 avenue de l Industrie | [NAME] | Orange | SDSL | 4Mbts | 2 | [NAME] |  | En preparation |  |  |  |  |  |  | A faire | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | A faire | 2018-07-26 00:00:00 | 0043UJA9 | 2018-07-10 00:00:00 |  |  |  |  |  |  |  |  | A FAIRE
Client 2 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043SZN3 | 2018-05-05 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 3 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | SDSL | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TEK1 | 2010-08-01 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 4 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | ADSL | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TFB6 | 2018-09-04 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 5 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TCP3 | 2018-07-06 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 6 | En cours | NON | TR | UnifyTelecom | 20 rue ANDRE DESSAUX | Fleury les Aubrais | Orange | Fibre | 100Mbts |  |  | [NAME] | Prêt |  | Partielle | fcecda40fddf |  |  |  | Inclus | NON |  |  |  | 2018-04-11 00:00:00 | 0043BZB2 | 2018-07-24 00:00:00 | 1ZW52F356894961686 |  | 14.22 | 2018-07-25 00:00:00 |  | 23 et 27/07/2018 |  |  | A FAIRE
Client 7 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-26 00:00:00 | 0043UGL3 |  |  |  |  |  |  |  |  |  | A FAIRE
Client 8 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-25 00:00:00 | 0043UKM4
Client 9 | En cours | NON | ID | Hexacom | 999 Chemin de Sauvecanne | Bouc Bel Air | Orange | SDSL | 4Mbts | 4 |  |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-23 00:00:00 | 0043EEL8 F59070230718 |  |  |  |  | 2018-08-06 00:00:00 |  | 2018-08-06 00:00:00
Spreadsheet: 195127d1353427773-calculating-overtime-and-regular-time-based-on-shift-schedule-shift-reg-time-v-ot-rv1
Sheet: v2

 | SHIFT START | SHIFT END
 | 7 | 15
DATE | START TIME | END TIME | TOTAL HOURS PER MAN | REG HOURS | OT HOURS | COMMENTS
2012-10-28 00:00:00 | 07:00:00 | 16:45:00
2012-10-30 00:00:00 | 14:30:00 | 22:36:00
2012-10-30 00:00:00 | 14:30:00 | 22:36:00
2012-10-31 00:00:00 | 07:00:00 | 13:00:00
2012-10-31 00:00:00 | 01:00:00 | 23:59:00
2012-11-01 00:00:00 | 00:00:00 | 00:52:00
2012-11-01 00:00:00 | 06:00:00 | 02:00:00 |  |  |  | "Total hours per man" [NAME] does not calculate property if time carries over to the next day
Spreadsheet: 41436d1239897483-cell-help-and-multiple-transpose-679970_sionos_2
Sheet: Sheet1

 | KEY |  | NAME | Address1 | Address2 | Address3 | Address4 | Address5 | Address6
Mr A | 1 |  | Mr A | Sarum College | Test1 | SALISBURY | x
Sarum College | 1.01 |  | Mr. [NAME] | a | d | SALISBURY | Wiltshire | f
Test1 | 1.02 |  | Mr. [NAME] | a | s | f | Postcode
SALISBURY | 1.03 |  | Mr. & Mrs. D | wwwww | wwwww | wwwww | wwwww | Tyne & Wear | wwwww
x | 1.04 |  | Mr. [NAME] | wwwww | wwwww | wwwww | SSO OQU
 | 1.05 |  | Ms, F | aaaaaa | aaaaaa | aaaaaa | Essex | aaaaaa
 | 1.06 |  | Mr. [NAME] | ssssss | ssssss | ssssss | Wiltshire | ssssss | ssssss
 | 1.07 |  | Mr. [NAME] | vvvvvvvv | vvvvvvvv | vvvvvvvv | SALISBURY | vvvvvvvv
 | 1.08 |  | Mrs. [NAME] | qqqqqq | qqqqqq | qqqqqq | qqqqqq | qqqqqq | qqqqqq
Mr. [NAME] | 2
a | 2.01
d | 2.02
SALISBURY | 2.03
Wiltshire | 2.04
f | 2.05
 | 2.06
 | 2.07
 | 2.08
Mr. [NAME] | 3
a | 3.01
s | 3.02
f | 3.03
Postcode | 3.04
 | 3.05
 | 3.06
 | 3.07
Mr. & Mrs. D | 4
wwwww | 4.01
wwwww | 4.02
wwwww | 4.03
wwwww | 4.04
Tyne & Wear | 4.05
wwwww | 4.06
 | 4.07
 | 4.08
Mr. [NAME] | 5
wwwww | 5.01
wwwww | 5.02
wwwww | 5.03
SSO OQU | 5.04
 | 5.05
 | 5.06
 | 5.07
 | 5.08
Ms, F | 6
aaaaaa | 6.01
aaaaaa | 6.02
aaaaaa | 6.03
Essex | 6.04
aaaaaa | 6.05
 | 6.06
 | 6.07
Mr. [NAME] | 7
ssssss | 7.01
ssssss | 7.02
ssssss | 7.03
Wiltshire | 7.04
ssssss | 7.05
ssssss | 7.06
 | 7.07
 | 7.08
 | 7.09
 | 7.1
Mr. [NAME] | 8
vvvvvvvv | 8.01
vvvvvvvv | 8.02
vvvvvvvv | 8.03
SALISBURY | 8.04
vvvvvvvv | 8.05
 | 8.06
Mrs. [NAME] | 9
qqqqqq | 9.01
qqqqqq | 9.02
qqqqqq | 9.03
qqqqqq | 9.04
qqqqqq | 9.05
qqqqqq | 9.06
Spreadsheet: 21955d1210204425-multiple-variables-in-formula-eval
Sheet: April2008

 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
Date | Staff | Patient | Charge | Code | Staff | Patient | Charge | Code | Staff | Patient | Charge | Code | Staff | Patient | Charge | Code | Staff | Patient | Charge | Code
2008-04-01 00:00:00 | BB | Patient1 | Charge5 | 5 | CC | Patient4 | Charge3 | 3 | BB | Patient21 | Charge1 | 1 | BB | Patient12 | Charge2 | 2 | DD | Patient19 | Charge2 | 2
 | EE | Patient2 | Charge0 | 0 | EE | Patient5 | Charge4 | 4 | EE | Patient7 | Charge3 | 3 | CC | Patient13 | Charge3 | 3 | AA | Patient20 | Charge4 | 4
 | AA | Patient3 | Charge5 | 5 | AA | Patient6 | Charge5 | 5 | MM | Patient8 | Charge4 | 4 | EE | Patient14 | Charge1 | 1
 | AA | Patient22 | Charge4 | 4 | AA | Patient23 | Charge4 | 4 | FF | Patient9 | Charge0 | 0 | AA | Patient15 | Charge4 | 4
 |  |  |  |  |  |  |  |  | DD | Patient10 | Charge5 | 5 | HH | Patient16 | Charge0 | 0
 |  |  |  |  |  |  |  |  | II | Patient11 | Charge1 | 1 | AA | Patient17 | Charge5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | GG | Patient18 | Charge0 | 0
2008-04-07 00:00:00
2008-04-14 00:00:00
2008-04-21 00:00:00
2008-04-28 00:00:00
Spreadsheet: 148709d1333529982-excel-2007-lookup-for-multiple-horizontal-values-testcenter_selection
Sheet: Sheet1

Technology | Product | SW Version | Center 1 | Center 2 | Center 3 | Center 4 | Center 5 | Center 6 | Center 7 | Center 8
Technology 1 | Product A-1 | Version A-1-1 |  | yes |  |  |  |  | yes
Technology 1 | Product A-1 | Version A-1-2 |  | yes |  | yes | yes | yes
Technology 1 | Product A-2 | Version A-2-1 |  | yes |  |  | yes
Technology 1 | Product A-3 | Version A-3-1 |  | yes | yes |  |  | yes
Technology 2 | [NAME] | Version B-1-1 | yes
Technology 2 | [NAME] | Version B-1-2 | yes |  |  |  | yes |  | yes
Technology 2 | Product B-2 | Version B-2-1 | yes |  | yes |  |  | yes | yes | yes
Technology 3 | Product C-1 | [NAME] | yes | yes | yes
Technology 1 | Product A-2 | Version A-2-1
Spreadsheet: 267407d1380066273-highlight-an-entire-row-based-upon-a-date-highlighting-rows-example
Sheet: Example

Unit # | Unit Type | Upgrade Details | Upgrade Cost - Less Flooring | Date Vacated/  Start Upgrade | Date Completed | Days to Complete Upgrade | Total Rent | Move In Date
001
002
003
004
005
Spreadsheet: 771363d1646645062-display-reference-values-that-are-only-equal-to-zero-excel-forum-7-march
Sheet: Sheet1

List of Codes 1 | Values | List of Codes 2 | Values | List of Codes 2 | Values |  |  | Preferrable display of Codes with Zero Values
A01 | 1 | A14 | 2 | A27 | 6 |  |  | A03 | A04 | A13 | A19 | A21 | A32 | A37 | A39
A02 | 2 | A15 | 4 | A28 | 7
A03 | 0 | A16 | 6 | A29 | 8
A04 | 0 | A17 | 8 | A30 | 9
A05 | 3 | A18 | 3 | A31 | 4
A06 | 4 | A19 | 0 | A32 | 0
A07 | 5 | A20 | 5 | A33 | 5
A08 | 6 | A21 | 0 | A34 | 9
A09 | 7 | A22 | 7 | [NAME] | 7
A10 | 8 | A23 | 6 | A36 | 5
A11 | 3 | A24 | 2 | A37 | 0
A12 | 3 | A25 | 1 | A38 | 8
A13 | 0 | A26 | 2 | A39 | 0
Spreadsheet: louise_kitchen__23833__2QYTD Orig2
Sheet: Top 10 Overall

June YTD 2001 Top 10 Originators by Value
Originator | Commodity | Team | Total
[NAME] | Power | West
[NAME] | Power | West | 36360000
Zufferli | Power | Canada
Tycholiz | Gas | West | 19943780
[NAME] | Power | West | 18123000
[NAME] | Gas | Derivatives | 12311290.02
Calger | Power | Canada | 10784435
Whitt | Gas | West | 10556290
Kroll | Power | Southeast | 7261000
Le Dain | Gas | Canada
Total
Spreadsheet: 768674d1645078978-index-match-offset-sumproduct-formula-for-forecasting-formula-for-forecasting-ans-2
Sheet: Steps Instructions

Currently I have yearly "Units" data under "Units" sheet.
I have 3 different tables under "Units" sheet.
No. | Table Name | Range From | Range To
1 | 2021 Actuals | H | T
2 | 2021 Budget | V | AH
3 | 2021 Forecasting | AJ | AV
3rd table "2021 Forecasting" is dynamic so the header of table (range "AJ to AV") does not read "2021 Forecasting" but shows how many actual months + how many remaining months (1 +11)
2021 Actuals has all actual units & both are static.
2021 Budget has all Budget Units.
I have to update 3rd table monthly based on which month we just passed.
I have limited skills with excel and currently I am copy pasting data for each month manually.
In 3rd Table "2021 Forecasting" I need dynamic table.
If we are in Feb 2022.
Then In 3rd table, I need data as below:
for Jan, I need actuals from "2021 Actuals" table
& from Feb to Dec I need data from "2021 Budget" table.
thus as you can see that both on "on "SUMMARY" sheet and on last table on "Units" the 2021 Forecasting table name is also dynamic.
as I just plugged in Jan 2021 Actual Unit values from "2021 Actual" table and remaining Units values from Feb to Dec is from Budget table, the dynamic name changes to  1 (Jan) to 11 (Feb to Dec)
I need your help with making this last table in range AJ to AV dynamic in a way that it fulfills below condition.
1 | If Table name shows 1+11 then It should pull actual values for Jan from "2021 Actuals" and remaning values of 11 months for Feb to Dec from "2021 Budget" table.
2 | If I change cell value on B6 "Summary" table then it should pull the 2021 Forecast table data accordingly.
 | i.e. If I put 2 in Cell B6 then 2021 Forecasting table should pull actual values for both Jan and Feb from 2021 Actuals and remaining 10 months (March to Dec) from 2021 Budget.
 | i.e. If I put 4 in Cell B6 then 2021 Forecasting table should pull actual values from Jan to April from 2021 Actuals and remaining 8 months (May to Dec) from 2021 Budget.
 | I saw some of the tutorials online and realized that, SUMPRODUCTS, OFFSET, INDEX and MATCH could be useful but as I mentioned earlier, I got lilmired skill set working with those formulas and was getting error.
 | Can you please help me with building formula so that my 3rd table in units tab becomes dynamics?
 | Thanks a lot in advance.
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Dauphin Cty Grt

 |  |  |  |  |  |  | 2013 Dauphin Cty Grant
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every Friday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 62644d1263548915-re-sizing-graphs-714156
Sheet: Sheet1

 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 0.85 | 0.75 | 0.94 | 0.94 | 0.83 | 0.99 | 0.96 | 0.97 | 0.89 | 0.91 | 0.79 | 0.85
Spreadsheet: 141597d1329348195-count-find-with-2-criterias-excel
Sheet: Sheet1

x | 2 | __
x | 3 | __
y | 1 | __
z | 1 | __
z | 2 | __
z | 2 | __
y | 3 | __
x | 3 | __
y | 2 | __
x | 1 | __
x | 1 | __
Spreadsheet: 152164d1335276274-ranking-on-particular-percentage-of-data-from-any-range-rating
Sheet: Sheet1

User | Total Point | Rank
[NAME] | 693.7333333333332
[NAME] | 417.5666666666667
[NAME] | 415.9266666666667
[NAME] | 268.1333333333334
Priyanshu [NAME] | 219.6266666666667
[NAME] | 178
[NAME] | 142.4
[NAME] | 89.50000000000003
[NAME] | 89.20666666666666
Prashant Singh | 86.5
[NAME] | 63
[NAME] | 55.96000000000001
[NAME] | 52.58666666666666
KHEEM SINGH | 41.73333333333334
[NAME] | 28.56000000000002
Ishita dutta | 26.38666666666668
Meenal Rohela | 7.333333333333333
Manisha Madhu | 0.6666666666666667
[NAME] | -4.013333333333321
[NAME] | -6.453333333333319
Samsul Choudhary | -59.14666666666665
[NAME] | -91.83999999999999
Mohinish Baluni | -205.4
Grand Total | 2509.966666666667
Spreadsheet: 82770d1282802628-how-to-define-auto-color-rows-two-week-programme
Sheet: Sheet1 (2)

Activity  ID | Activity Description |  |  |  | Actual %Comp | Early       Start | Early    Finish | Late   Start | Late Finish | 2010
 |  |  |  |  |  |  |  |  |  | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-29 00:00:00 | 2020-08-30 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 14
001 | excavation Works |  |  |  |  | 2010-08-24 00:00:00 | 2010-08-30 00:00:00
002 | Concrete Works |  |  |  |  | 2010-08-25 00:00:00 | 2010-08-31 00:00:00
Spreadsheet: john_forney__15542__fronteracalc
Sheet: frontera's calc

PARAMETERS
 | Options Exercised 0700 - 2200
 | HSC = $2.48
 | Sales = 300 MW's, 0700 - 2200 @ $25
 | Production HR = 7.7
 | Start-up HR = 18
 | VOM = 2.75/MW
 | Start-up sequence = 30, 30, 30, 135, 200
 | FRONTERA REVENUE - VARIABLE O&M CALC
REVENUE |  | Price | MW's | HR |  | Total
 | Options | 21.89 | 2400
 | Other | 25 | 4800
VOM |  | 2.75 | 7440
GAS | HSC + .10 | 2.58 | 7200 | 7.7
 |  |  |  | Subtotal
START-UP COSTS |  | Price | MW's | HR
 | Sales | 7 | 425
 | Gas | 2.58 | 425 | 18
 |  |  |  | Subtotal
 |  |  | Grand Total
Spreadsheet: 812416d1673127013-roster-calculations-trying-to-count-number-of-weeks-worked-calendar
Sheet: Total Hours and Weeks

 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
800 | Teacher 1
800 | Teacher 2
480 | Teacher 3
800 | Teacher 4
800 | Teacher 5
800 | Teacher 6
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
 |  | Number of classes
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
Spreadsheet: 808279d1670381851-pc-asset-tracker-get-value-in-new-sheet-sample-pc-asset-tracker
Sheet: Berlin

Asset Tag 2 | Serial No | Hostname 2 | Brand | Model | Type | Service Start | Service End | Status | Owner | Departement | Location
22k. 70B.D001 | 22K.70.D084 | BERNBLGL001 | HP | HP ProBook 440 G8 16 Gb | Notebook | 2022-02-18 00:00:00 | 2026-02-18 00:00:00 | Active | [NAME] | Legal | Berlin
Spreadsheet: 120752d1315497918-multiple-results-sample
Sheet: Deal Structure

Table of Contents
 | SAMPLE DEAL STRUCTURE
 | Start Date |  | 2011-01-01 00:00:00 |  |  | IRR to lessee
 | Deal Size |  | 22000 |  |  | Net IRR of deal
 | Commission Sub Broker |  |  | 0
 | Commission Broker |  |  | 0 |  | Cost of Funds
 | Loan Fee: |  |  |  |  | (includes annual maintenance fee)
 | Overhead Expense:
 | Up Front Payments |  |  |  |  | Income Tax
 | Total Net Outlay
 | Term: |  | 24
 | Upfront Payments |  | 0
 | Annual Depreciation |  | 0.12
 | Value at lease end as % of original cost |  |  |  |  | (pv of the fv for one month since FV paid one month after last lease payment)
 | Monthly Payment:
 | EARNINGS SUMMARY
 | Total Payments | Principal Reduction | Average Outstanding | Gross Interest | as % of Deal Size | as % of Outstanding | Net Interest | as % of Deal Size | as % of Outstanding
2011
2012
2013
2014
2015
 |  |  |  |  |  | average |  |  | average
 | MONTHLY AMORTIZATION
Year |  | End of Month | Payment | Interest Earned | Principal Reduction | Remaining Balance | Cost of Funds | Net | Taxes | Net After Tax
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 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
Spreadsheet: 840661d1692893306-detect-and-remove-outliers-from-dataset-exposure_
Sheet: Final

Hospital | Bug | Drug | Drug_Bug | TestNumbers | Susceptibility | Tests_Susceptible
ABC | Ecoli | MC | Ecoli_MC | 122 | 0.5 | 61
ABC | Ecoli | MN | Ecoli_MN | 34 | 0.5 | 17
ABC | Kleb | MN | [NAME] | 200 | 0.9 | 180
ABC | Kleb | MC | Kleb_MC | 55 | 0.8 | 44
ABC | [NAME] | MN | [NAME] | 143 | 0.01 | 1.43
ABC | [NAME] | MC | Auris_MC | 13 | 0.7 | 9.1
ABC | [NAME] | FL | Auris_FL | 500 | 0.7 | 350
ABC | Kleb | FL | Kleb_FL | 113 | 0.4 | 45.2
XYZ | Kleb | MN | [NAME] | 100 | 0.6 | 60
XYZ | Ecoli | MC | Ecoli_MC | 233 | 1 | 233
XYZ | Kleb | MC | Kleb_MC | 33 | 1 | 33
XYZ | Ecoli | FL | Ecoli_FL | 112 | 1 | 112
XYZ | Kleb | FL | Kleb_FL | 100 | 0.8 | 80
XYZ | Ecoli | MN | Ecoli_MN | 212 | 1 | 212
XYZ | [NAME] | MN | [NAME] | 78 | 0.9 | 70.2
XYZ | [NAME] | FL | Auris_FL | 23 | 1 | 23
RTY | Kleb | MN | Kleb_Mn | 50 | 0.6 | 30
RTY | Ecoli | MC | Ecoli_MC | 230 | 0.1 | 23
RTY | Kleb | MC | Kleb_MC | 440 | 0.8 | 352
RTY | Kleb | FL | Kleb_FL | 56 | 0.8 | 44.8
RTY | Ecoli | MN | Ecoli_MN | 20 | 0.9 | 18
RTY | Ecoli | FL | Ecoli_FL | 40 | 0.5 | 20
RTY | [NAME] | FL | Auris_FL | 29 | 0.8 | 23.2
RTY | [NAME] | MN | [NAME] | 88 | 0.9 | 79.2
RTY | [NAME] | MC | Auris_MC | 90 | 0.1 | 9
HOW | Kleb | MN | Kleb_Mn | 50 | 0.4 | 20
HOW | Ecoli | MC | Ecoli_MC | 90 | 0.8 | 72
HOW | Kleb | FL | Kleb_FL | 70 | 0.1 | 7
HOW | Ecoli | MN | Ecoli_MN | 389 | 0.3 | 116.7
HOW | Ecoli | FL | Ecoli_FL | 120 | 0.7 | 84
HOW | [NAME] | FL | Auris_FL | 35 | 1 | 35
HOW | [NAME] | MN | [NAME] | 99 | 0.2 | 19.8
HOW | [NAME] | MC | Auris_MC | 20 | 0.1 | 2
CVS | Kleb | MN | Kleb_Mn | 50 | 0.4 | 20
CVS | Ecoli | MC | Ecoli_MC | 312 | 0.4 | 124.8
CVS | Kleb | MC | Kleb_MC | 44 | 0.6 | 26.4
CVS | Kleb | FL | Kleb_FL | 300 | 0.5 | 150
CVS | Ecoli | MN | Ecoli_MN | 60 | 0.4 | 24
CVS | Ecoli | FL | Ecoli_FL | 100 | 0.7 | 70
CVS | [NAME] | MN | [NAME] | 344 | 0.2 | 68.8
CVS | [NAME] | MC | Auris_MC | 789 | 0.6 | 473.4