tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: edc5e5b3-fd53-4448-923f-acef7aba1df3
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Human Resources | 1 | Hire additional Human Resources Generalist | None | -- Pick One -- | 1.1.r1 | Hiring HR Generalist | OnGoing | 75000 | 0 | 70000 | 0 | 72000 | 0 | 0 | 0
Human Resources | 3 | Hire Human Resources Benefits Specialist | None | -- Pick One -- | 1.2.r1 | Hiring Benefit Specialist | OnGoing | 75000 | 20000 | 70000 | 30000 | 72000 | 35000 | 0 | 0
Human Resources | 4 | Hire Employee Relations Specialist | None | -- Pick One -- | 1.3.r1 | Hiring Employee Relations Specialist | OnGoing | 75000 | 50000 | 70000 | 60000 | 72000 | 70000 | 0 | 0
Human Resources | 9 | Effectively and consistently communicating information to our clientele | None | -- Pick One -- | 1.4.r1 | Costs of using Social Media | OnGoing | 5000 | 0 | 5000 | 0 | 5000 | 0 | 0 | 0
Human Resources | 9 | Effectively and consistently communicating information to our clientele | None | -- Pick One -- | 1.4.r2 | Costs of implementing internal wiki | OnGoing | 2000 | 0 | 500 | 0 | 500 | 0 | 0 | 0
Human Resources | 8 | Reduce the cycle time for recruitments | None | -- Pick One --
Human Resources | 14 | Revisit a Mentoring Program for New Hires | None | -- Pick One --
Human Resources | 2 | Conduct a salary survey to ensure competitive compensation | None | -- Pick One --
Human Resources | 12 | Reduce the number of worker's compensation claims files | None | -- Pick One -- | 3.1.r1 | Cost of reducing work comp claims | OnGoing | 75000 | 20000 | 70000 | 30000 | 72000 | 35000 | 0 | 0
Human Resources | 15 | Develop a Health and Wellness Program | None | -- Pick One -- | 3.2.r1 | Costs of [NAME] for Health and Wellness | OnGoing | 75000 | 20000 | 70000 | 30000 | 72000 | 35000 | 0 | 0
Human Resources | 16 | Provide District issued identification cards to all faculty, staff and administration. | None | -- Pick One -- | 3.3.r1 | Initial purchase of supplies & equipment | OnGoing | 35000 | 0 | 7500 | 0 | 7500 | 0 | 0 | 0
Human Resources | 6 | Vice Chancellor will review staffing plan with the department. Will ensure that managers are up to date. | None | -- Pick One --
Human Resources | 7 | Update Human Resources Board Policies and Administrative Procedures | None | -- Pick One --
Human Resources | 5 | Create a Human Resources Standard Operating Procedures Manual | None | -- Pick One -- | 5.2.r1 | Procedures Manual and Employee Handbook | OnGoing | 5000 | 0 | 1500 | 3500 | 750 | 4250 | 0 | 0
Human Resources | 13 | Develop Employee Handbook | None | -- Pick One --
Human Resources | 10 | Conduct a Training Needs Assessment with assistance from Environmental, Health and Safety Administrator | None | -- Pick One --
Human Resources | 11 | Develop a training program for managers and classified employees. | None | -- Pick One --
Spreadsheet: 684058d1593116091-index-array-small-if-trouble-not-pulling-last-result-index-array-problem
Sheet: Sheet1

 |  |  | [NAME],SMALL(IF(PO_Item=$A6,ROW(PO_Item)-MIN(ROW(PO_Item))+0,""),COLUMN()-3)), "") |  |  |  |  |  |  |  |  |  | Had to change to +0 to get the first date to show.
 |  |  |  |  | [NAME],SMALL(IF(PO_Item=$A6,ROW(PO_Item)-MIN(ROW(PO_Item))+0,""),COLUMN()-3)), "")
 |  |  |  |  |  | [NAME],SMALL(IF(PO_Item=$A6,ROW(PO_Item)-MIN(ROW(PO_Item))+0,""),COLUMN()-3)), "")
 |  |  |  |  |  |  | [NAME],SMALL(IF(PO_Item=$A6,ROW(PO_Item)-MIN(ROW(PO_Item))+0,""),COLUMN()-3)), "")
Item | Qty 1 | Qty 2 | Qty 3 | Date 1 | Date 2 | Date 3
19083 | 30
19090 | 150 | 100 | 450 | 2020-06-26 00:00:00 | 2020-07-17 00:00:00 | 2020-07-24 00:00:00 | This one works because there are more results than we're searching for.
19091 | 150 | 450 | 450 | 2020-06-26 00:00:00 | 2020-07-17 00:00:00
19092 | 300 | 450 | 150 | 2020-07-24 00:00:00 | 2020-08-04 00:00:00
19093 | 150 | 300 |  | 2020-07-24 00:00:00
19094 | 50 | 100 |  | 2020-06-26 00:00:00
 |  |  | =IFERROR(INDEX(PO_BO_Qty,SMALL(IF(PO_Item=$A8,ROW(PO_Item)-MIN(ROW(PO_Item))+1,""),COLUMN()-1)), "")
 | In each of these cells, the missing date is the last row matching
Pulling data from…
PO_Item |  |  |  | PO_DEL |  |  | PO_BO_qty
Item | Date | Num | Name | Deliv Date | Qty | [NAME] | Backordered
19083 | 2020-03-26 00:00:00 | xxx | xxx | 2020-07-24 00:00:00 | 30 | 0 | 30
19090 | 2020-03-02 00:00:00 | xxx | xxx | 2020-06-26 00:00:00 | 150 | 0 | 150
19090 | 2020-03-13 00:00:00 | xxx | xxx | 2020-07-17 00:00:00 | 100 | 0 | 100
19090 | 2020-03-31 00:00:00 | xxx | xxx | 2020-07-24 00:00:00 | 450 | 0 | 450
19090 | 2020-05-11 00:00:00 | xxx | xxx | 2020-08-04 00:00:00 | 300 | 0 | 300
19090 | 2020-06-02 00:00:00 | xxx | xxx | 2020-08-28 00:00:00 | 150 | 0 | 150
19091 | 2020-03-02 00:00:00 | xxx | xxx | 2020-06-26 00:00:00 | 150 | 0 | 150
19091 | 2020-03-13 00:00:00 | xxx | xxx | 2020-07-17 00:00:00 | 450 | 0 | 450
19091 | 2020-05-11 00:00:00 | xxx | xxx | 2020-08-04 00:00:00 | 450 | 0 | 450
19092 | 2020-03-31 00:00:00 | xxx | xxx | 2020-07-24 00:00:00 | 300 | 0 | 300
19092 | 2020-05-11 00:00:00 | xxx | xxx | 2020-08-04 00:00:00 | 450 | 0 | 450
19092 | 2020-06-02 00:00:00 | xxx | xxx | 2020-08-28 00:00:00 | 150 | 0 | 150
19093 | 2020-03-31 00:00:00 | xxx | xxx | 2020-07-24 00:00:00 | 150 | 0 | 150
19093 | 2020-05-11 00:00:00 | xxx | xxx | 2020-08-04 00:00:00 | 300 | 0 | 300
19094 | 2020-03-02 00:00:00 | xxx | xxx | 2020-06-26 00:00:00 | 50 | 0 | 50
19094 | 2020-03-31 00:00:00 | xxx | xxx | 2020-07-24 00:00:00 | 100 | 0 | 100
Spreadsheet: 5f5cae4f-4265-4fcb-a9ce-c161b510347e
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Latin American Studies
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 817746d1676424419-calculating-payment-due-dates-automatically-subscription-tracker-1-
Sheet: Interface

 | Service details |  |  | Billing period |  |  |  |  |  | Context
 | Subscription | Date commenced | Payment Next Due | QTY | Unit |  |  |  |  | 1 | The date as of me creating this is 14 Feb 23.
 | Spotify | 2019-12-18 00:00:00 |  | 12 | m |  |  |  |  | 2 | The cells that are highlighted orange are user input. (Column B, C, E, F)
 | ExpressVPN | 2022-04-19 00:00:00 |  | 3 | m |  |  |  |  | 3 | The cells that are white with orange text are automatic calculations. (Column D)
 | Hulu | 2021-07-21 00:00:00 |  | 1 | m |  |  |  |  | 4 | Column D (Payment Next Due) needs to update every time the previous due date has passed.
 | [NAME] | 2023-01-29 00:00:00 |  | 1 | w |  |  |  |  | 5 | Cell [NAME] is left blank to provide space for solution.
 | Amazon Prime | 2023-02-11 00:00:00 |  | 1 | d |  |  |  |  | 6 | Problem: How do I create the auto-calculations for column D? Thank you for your time.
 | MasterClass | 2023-02-12 00:00:00 |  | 2 | d
 | Tidal | 2023-02-13 00:00:00 |  | 3 | d
 | Apple Music | 2021-11-09 00:00:00 |  | 12 | m
 | HubSpot | 2022-08-16 00:00:00 |  | 1 | m
 | Zenefits | 2020-07-22 00:00:00 |  | 1 | m
 | Disney+ | 2023-01-06 00:00:00 |  | 1 | w
 | Audible | 2022-04-26 00:00:00 |  | 1 | d
 | GrandBox | 2021-11-11 00:00:00 |  | 3 | m
 | Kindle Direct | 2021-02-11 00:00:00 |  | 3 | m
 | Netflix | 2022-01-09 00:00:00 |  | 12 | m
 | [NAME]
Spreadsheet: 16b69308-13bc-4812-bf3f-50d52f2d21ea
Sheet: Sheet1

Rozpočet projektu | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
P.č. | Aktivita | Skupina výdavkov | [NAME] položky | [NAME] | [NAME] | Počet jednotiek | Celkom | Podrobný [NAME] a k spôsobu výpočtu položky *
Priame výdavky
1
2
3
4
5
6
7
8
9
10
11
12
13
n
Celkom priame výdavky |  | X | X | X | X | X |  | X
Nepriame výdavky
1
2
3
4
5
6
7
n
Celkom nepriame výdavky |  | X | X | X | X | X |  | X
Celkom
Celkom priame výdavky:
Celkom nepriame výdavky:
Rezerva na nepredvídané výdavky:
Celkom krížové financovanie:
* Odôvodniť opodstatnenosť každej položky rozpočtu, uviesť prepojenie s príslušnými aktivitami  a spôsob výpočtu položiek.  [NAME] v rozpočte zaokrúhľovať matematicky na 2 desatinné miesta. [NAME] môže byť vytvorený v dokumente Word a zaradený ako osobitná príloha k rozpočtu.
V stĺpci B Aktivita uvádzať pri priamych výdavkoch rámcovú aktivitu a pri nepriamych výdavkoch aktivitu [NAME] projektu alebo aktivitu Publicita a informovanosť.
V stĺpci C skupina vydavkov [NAME] v poradí podľa číselníka [NAME], samostatne pre priame výdavky a samostatne pre nepriame výdavky.
Spreadsheet: a98dda3d-f308-4297-99f5-e759cb978d99
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Møbeltapetserere
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Wiels Møbeltapetsererverksted |  | 1954 | [NAME] | 928 94 433
Porsanger Arbeidssamvirke AS | Laatasv. | 9700 | [NAME] | 78 46 15 22 | 78 46 18 51
Bjørno's Møbeltapetsering | Brusetsvingen 27 | 1395 | Hvalstad | 66 84 84 20
[NAME] | Blektjernveien 11A | 3046 | Drammen | 32 83 50 14
Bergen Håndtverkssenter AS | [NAME] | 5179 | Godvik | 55 94 13 20 | 55 26 44 00
Walløe & Nilsen AS | Nattlandsveien 155 | 5094 | Bergen | 55 90 11 40
Interiørservice | Hvalsmoen 146 | 3514 | Hønefoss | 991 56 780
Os [NAME] | Borgavegen 12 | 5211 | Os | 940 38 811
[NAME] | Finsalvegen 92 | 2322 | Ridabu | 934 39 877
Sara søm og møbeltapetsering | Prinsessegata 1 | 3724 | Skien | 35 52 58 03 | 35 52 58 03
[NAME] | Kongshavns gata 1A | 3970 | Langesund | 905 16 738
[NAME] | [NAME] | 3095 | Eidsfoss | 33 05 72 40
[NAME] | Hagen | 1827 | [NAME] | 69 92 43 50 | 69 92 43 51
[NAME] | Tvetenveien 32B | 0666 | Oslo | 22 65 06 80
Nadine Møbeltapetserverksted | Nordstrandveien 56C | 1163 | Oslo | 958 88 588
[NAME] | Normannsgata 43 | 0655 | Oslo | 22 68 10 00
Sidsels Tapetserverksted | Sandsbrauta 2 | 4230 | Sand | 959 47 018
Øvre Hove Møbeltapetsering | Hove | 6893 | [NAME] | 950 55 584
Bergmanns Møbelverksted H | A J Horgens vei 9 | 3055 | [NAME] | 902 07 465
Fagsøm AS | Industriveien 9 | 9360 | Bardu | 77 18 28 88 | 77 18 28 89
[NAME] | [NAME] gate 30 | 0472 | Oslo | 958 79 270
[NAME] | [NAME] 21 | 3138 | Skallestad | 33 32 01 00
Stopp hos meg [NAME] | Strandgata 1 | 4950 | [NAME] | 37 15 33 62
[NAME] avd Trondheim | Borgosen | 7370 | Brekkebygd | 72 41 31 42
Møbelservice Marianne Sommerstad | Bispeveien 783 | 3174 | Revetal | 33 39 64 40
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Maintenance Reserves

[NAME]
 |  | 0 | 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
Number of Starts to [NAME]
Number of Starts per Year
Total Cumulative Starts
Annual Overhaul Accrual Expense
Estimated Cost Schedule for 120 Starts |  |  | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0
Cumulative Overhaul Accrual Expense
Annual Overhaul Accrual Interest Income
Cumulative Overhaul Accrual Interest Income
Annual Growth of Total Cost |  | 0.065
Sales & Use Tax on Fuel | 0.05 |  |  | NO. of Starts Per Yr. | Major [NAME] | Fuel | Total/Start Cost | Fuel % | Main %
Fuel Price | 2.5
Fuel /Start/Turbine |  |  |  | 20
 |  |  |  | 30
WH501F | 1 |  |  | 40
WH501FD | 2 |  |  | 50
 |  |  |  | 60
 |  |  |  | 70
 |  |  |  | 80
 |  |  |  | 90
 |  |  |  | 100
 |  |  |  | 110
 |  |  |  | 120
 |  |  |  | 130
 |  |  |  | 140
 |  |  |  | 150
 |  |  |  | 160
 |  |  |  | 170
 |  |  |  | 180
 |  |  |  | 190
 |  |  |  | 200
 |  |  |  | 210
 |  |  |  | 220
 |  |  |  | 230
 |  |  |  | 240
 |  |  |  | 250
Spreadsheet: 790949d1660073447-dynamic-priority-list-priority-puzzle
Sheet: Sheet1

What I Have |  |  |  |  |  |  |  |  | What I Want
Approval | APPBOOL | LVL | Priority |  | RAW Rank | Maintenance START | Completed Date |  | Approval | APPBOOL | LVL | Priority |  | RAW Rank | Maintenance START | Completed Date
 | True | 10 |  |  |  | 2022-07-28 00:00:00 | 2022-08-01 00:00:00 |  |  | True | 10 |  |  |  | 2022-07-28 00:00:00 | 2022-08-01 00:00:00
 | True | 2 |  |  |  | 2022-08-08 00:00:00 |  |  |  | True | 2 |  | 5 |  | 2022-08-08 00:00:00
 | True | 2 |  |  |  |  |  |  |  | True | 2 |  | 4
 | True | 2 |  |  |  | 2022-08-26 00:00:00 |  |  |  | True | 2 |  | 2 |  | 2022-08-26 00:00:00
 | True | 1 |  |  |  | 2022-09-30 00:00:00 |  |  |  | True | 1 |  | 1 |  | 2022-09-30 00:00:00
 | True | 3 |  |  |  | 2022-08-01 00:00:00 |  |  |  | True | 3 |  | 3 |  | 2022-08-01 00:00:00
 | False | 10 |  |  |  |  |  |  |  | False | 10
 |  |  |  |  |  |  |  |  | Note: There is not actualy logic in column N but this is what I would like to happen and is a visual demo
Spreadsheet: cd3025f5-8e10-4f80-b586-8ad258b7ba3e
Sheet: Per Pound

 |  |  |  | Feed
 |  |  | Feed Number | 1 | 2 | 3 | 4
 |  |  | Description
 | 3 |  | Price per Unit
 | 4 |  | Pounds per unit
 | 5 | Nutrient values | %DM
 | 6 |  | %CP
 | 7 |  | %TDN
 | 3 | Cost per Pound of Nutrient Purchased | CP $ per lb
 | 4 |  | TDN $ per lb
 | 5 |  | DM $ per lb
 | 11 | Freight | Rate per mile
 | 12 |  | [NAME]
 | 13 |  | Units per load
 | 14 |  | Cost per unit
 | 15 |  | Waste (per cent)
 | 16 |  | Per cent delivered
 | 6 | Cost per Pound of Nutrient Delivered | CP $ per lb
 | 7 |  | TDN $ per lb
 | 8 |  | DM $ per lb
 | 17 | Storage | Cost per unit
 | 18 |  | Waste (per cent)
 | 19 |  | Per cent fed
 | 9 | Cost per Pound of Nutrient Fed | CP $ per lb
 | 10 |  | TDN $ per lb
 | 11 |  | DM $ per lb
 | 20 | Feeding | Cost per unit
 | 21 |  | Waste (per cent)
 | 22 |  | Per cent consumed
 | 12 | Costs per Pound of Nutrient Consumed | CP $ per lb
 | 13 |  | TDN $ per lb
 | 14 |  | DM $ per lb
Spreadsheet: 884604d1733836635-calculation-formulas-based-on-dates-2024-investment
Sheet: Investments (2)

 | Reference number | Bank | Investment Date | Maturity Date | Initial Deposit Amount | Annual Interest Rate | Deposit Duration (Days) | Status | Total Interest Earned | Total Amount to Return | ROI | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Riyad | 2024-11-01 00:00:00 | 2024-12-03 00:00:00 | 33000000 | 0.05
 |  | Riyad | 2024-11-02 00:00:00 | 2024-12-04 00:00:00 | 33000001 | 0.0515
 |  | Riyad | 2024-11-03 00:00:00 | 2024-12-05 00:00:00 | 33000002 | 0.04
 |  | Riyad | 2024-11-04 00:00:00 | 2024-12-06 00:00:00 | 33000003 | 0.045
 |  | Riyad | 2024-11-05 00:00:00 | 2024-12-07 00:00:00 | 33000004 | 0.055
Spreadsheet: 34809d1232141842-how-can-i-move-columns-1-2-3-4-to-all-be-in-column-1-offset-example
Sheet: Sheet1

1 | 2 | 3 | 4 | 1
5 | 6 | 7 | 8 | 2
9 | 10 | 11 | 12 | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
Spreadsheet: 164862d1340911092-if-cell-is-y-then-put-rows-information-into-certain-area-of-another-sheet-help-fulldailymold-copy
Sheet: Disa 1

DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 1 | OF | 1
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
20:00:00 | 22:10:00 | 20 | P111 |  |  |  |  | M1111 |  |  | 0 |  | Y | <-- So because this is a "Y" I would want to transfer the MO. To the CORE USAGE Sheet
22:10:00 | 22:20:00 | 9350
 |  | 9170 |  |  |  |  |  |  |  |  |  | #N/A
23:00:00 | 23:10:00 | 20 | P123 |  |  |  |  | M2222 |  |  | 0 |  | N | <----This is a "N' so I don’t want to transfer it
23:10:00 | 23:20:00 | 9874
 |  | 9170 |  |  |  |  |  |  |  |  |  | #N/A
23:25:00 | 23:35:00 | 20 | P456 |  |  |  |  | M333 |  |  | 0 |  | Y | <----- This MO I do need to transfer over
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 2 | OF | 2
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
DATE: |  |  |  | DAILY MODLING PRODUCTION |  |  |  |  | PAGE: | 3 | OF | 3
EMP.NO: |  |  | NAME: |  |  |  | SHIFT: |  | WORK CTR: |  | MACH.NO: | 4000
START TIME | END TIME | OPER. NO. | PATTERN NO. | MOLDS MADE | MOLDS DESTROYED | MOLDS CLOSED | PART NO. | M.O. | PART RATE | IMP | PCS. MADE | DOWNTIME  (MINS) | CORED (Y/N)
Spreadsheet: 876844d1723557010-nested-if-statement-on-different-day-and-time-ifdaytime
Sheet: Sheet2

Day |  |  | Thu
Systems | Mon - Thur |  | Friday |  | Availability | Input from user
App1 | 08:00:00 | 19:30:00 | 08:00:00 | 19:30:00 |  | 08:31:00
App2 | 08:00:00 | 21:00:00 | 08:00:00 | 21:00:00 |  | 08:01:00
App3 | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00 |  | 08:45:00 | If statement with different day and time
App4 | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00 |  | 08:43:00 | If statement with different day and time
App5 | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00 |  | 17:45:00
Spreadsheet: 272831d1382526400-lookup-please-help-or-do-i-need-a-macro-ef512_copy_completed_records
Sheet: Overview_new

Completed Task Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sorting table |  |  |  |  |  | Running totals
Task Total | EMBARK DATE | EMBARK LOCATION | DISEMBARK LOCATION | EXPORT LICENSE | DISEMBARK DATE | START STATE | DATE | PROJ | VESSEL | ROUNDS FIRED | TEAM LEADER | [NAME] | END STATE | KIT |  | row_here | sheet | row_there | date | rank |  | sheet | start | last
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KIT001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KIT002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KIT003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <== add other sheet names as needed
Spreadsheet: 708470d1607859705-what-function-to-use-to-split-categories-book1
Sheet: Sheet1

 |  | Column 1 | Column 2 | Column 3 |  |  | Search term | Code
 |  | This is a sentence |  |  |  |  | Yadda yadda | YY1
 |  | Today is yadda yadda Sunday |  |  |  |  | [NAME] | BB1
 |  | [NAME] blah for [NAME] |  |  |  |  | [NAME] | DD1
 |  | this is a load of blah
 |  | Hi there doobedooobedoo
Spreadsheet: benjamin_rogers__1160__Model5
Sheet: Caledonia

INCOME STATEMENT - CALEDONIA
('000 $) |  | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Fuel |  | 0 | 0 | 0
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Up Power
Property, Other Taxes |  | 549.1636983741149 | 538.069482245345 | 526.9752661165749
Mobilization |  | 0 | 0 | 0
Marketing Fee |  | 0 | 0 | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 2000-01-31 00:00:00 | 2000-02-22 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00
Revenue (Real) | 213.762 | 148.109 | 1.338 | 34.911 | 88.284 | 371.741 | 5537.11 | 16315.949 | 18123.804 | 805.833 | 91.367 | 37.225 | 45.899 | 146.863 | 151.539 | 41.308 | 115.687 | 405.809 | 4102.014 | 11296.069 | 11992.961 | 741.936 | 121.843 | 46.13 | 57.551 | 152.55 | 151.912 | 45.919 | 129.439 | 391.819 | 3130.818 | 8315.057 | 8259.486 | 795.563 | 127.079 | 45.227 | 61.834
USD Libor |  |  | 0.0605681254028103 | 0.0605681254028103 | 0.0605681254028103 | 0.0614528938500749 | 0.062272420332016 | 0.0631418102820942 | 0.063791031540835 | 0.0644402529393635 | 0.0650281821846135 | 0.0655609806482027 | 0.0660765921541437 | 0.0665800294961341 | 0.0670369781793325 | 0.0674497060816499 | 0.0678640776304542 | 0.0681889253242094 | 0.0685246013111129 | 0.0688295340127438 | 0.0691069719563195 | 0.0693844099253584 | 0.0696329433757978 | 0.069856963974845 | 0.0700737581187561 | 0.07028720190671 | 0.0704860008481814 | 0.0706655611936435 | 0.0708378099668314 | 0.070965582403328 | 0.0710976139267086 | 0.0712170959618539 | 0.0713268914821796 | 0.0714366870064884 | 0.0715344306947476 | 0.0716232034710216 | 0.0717091126118303
Revenue (Nominal)
MW
Prices
 | Nominal Revenue | Capacity $
2000
2001
2002
Spreadsheet: 086ffc82-cafd-46fa-b99d-6d493ef5c784
Sheet: General

General Information
Instructions
 | Fill in the yellow highlighted areas
 | Service Name (short) - A short name of the service.  For example: [NAME], field tests, etc.
Contact Information
 | Name
 | [NAME]
 | Phone #
 | Department
Service Center Name
Budget #
Most Recent Complete Fiscal Year Information (Statement of Changes - FWRDSTR)
 | Previous fiscal year carryover
 | Revenue
 | Expenditures
 | Transfers
 | Ending balance
 | Service Name (short) | Brief description of the service | Current rate | Unit* | Estmated # of annual units
1)
2)
*Unit is how the rate is charged such as per hour, each, etc.
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -28738
3531 | -264836 | -254501
60667 | -187129 | -242138
60749 |  | -138125
61206
61334 | -160368
62960
INDEX
2000-11-30 00:00:00 |  |  | 52631.01
2000-12-09 00:00:00
Spreadsheet: 185199d1349553758-how-to-merge-two-data-sets-to-create-a-single-large-data-set-ef212_october-3-2012-help-file-v2
Sheet: Sheet1

Step 1 | Step 2 |  | Names | Data |  | names | data
Name 1 | Data1
Name 2 | Data2
Name 3 | Data3
name4 | New Data 4
 | New Data 5
 | New Data 6
 | New Data 7
 | New Data 8
 | New Data 9
 | New Data 10
Spreadsheet: 780680d1652684292-recall-text-from-different-cells-into-one-book1
Sheet: Mainsheet

Actual |  |  |  |  |  |  |  | Expected Result
REF | Details : |  |  |  |  |  |  | REF | Details :
1 |  |  |  |  |  |  |  | 1 | aaa bbb  [NAME]
2 |  |  |  |  |  |  |  | 2 | ddd  eee fff
3 |  |  |  |  |  |  |  | 3 | [NAME]  iii jjj