tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50850d1250364098-pasting-excel-tables-to-powerpoint-den1
Sheet: Sheet1

 | Income figures € x 1.000
 | OPERATIONAL BUCKET | BP Income | Actual Income | GLA -BP | GLA -Actual | Leased out Income | Leased out Sqm | % Leased out by income | % Leased out by Sqm | Tenant Incentives | Of which cash contribution
 | UNDER CONSTRUCTION BUCKET | BP Income | Actual Income | GLA -BP | GLA -Actual | Leased out Income | Leased out Sqm | % Leased out by income | % Leased out by Sqm | Tenant Incentives | Of which cash contribution
 | UNDER DEVELOPMENT BUCKET | BP Income | Actual Income | GLA -BP | GLA -Actual | Leased out Income | Leased out Sqm | % Leased out by income | % Leased out by Sqm | Tenant Incentives | Of which cash contribution
Spreadsheet: 3b890cbd-ae04-4f5f-af85-8065ccba5fb1
Sheet: Sheet1

Table 4--U.S. fiber demand | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Oct. | Nov. | Dec. |  | Dec.
Item | 2013 | 2013 | 2013 |  | 2012
 | 1,000 480-lb. [NAME]
Cotton:
All consumed by mills 1/ | 315 | 282 | 243 |  | 233
Total since August 1 | 944 | 1226 | 1470 |  | 1396
Daily rate | 13.7 | 13.4 | 11.1 |  | 11.1
Upland consumed by mills 1/ | 313 | 281 | 242 |  | 232
Total since August 1 | 940 | 1221 | 1463 |  | 1390
Daily rate | 13.6 | 13.4 | 11 |  | 11
Upland exports | 375 | 399 | 741 |  | 855
Total since August 1 | 1774 | 2173 | 2914 |  | 3369
Sales for next season | 13 | 73 | 59 |  | 40
Total since August 1 | 178 | 251 | 310 |  | 543
Extra-long staple exports | 39 | 83 | 65.5 |  | 42.4
Total since August 1 | 137.7 | 220.7 | 286.2 |  | 292.7
Sales for next season | 0 | 0 | 0 |  | 0
Total since August 1 | 0 | 0 | 0 |  | 4.4
 | Sep. | Oct. | Nov. |  | Nov.
 | 2013 | 2013 | 2013 |  | 2012
 | Million pounds
Manmade:
Raw fiber exports | 54.2 | 53.4 | 46 |  | 52.4
Noncellulosic | 53.6 | 52.7 | 45.3 |  | 51.9
Cellulosic | 0.6 | 0.7 | 0.7 |  | 0.5
Total since January 1 | 499.6 | 552.9 | 598.9 |  | 630.2
Total since January 1
 | 1,000 pounds
Wool and mohair:
Raw wool exports, clean | 496.3 | 837.9 | 694.1 |  | 917.8
Total since January 1 | 7766.7 | 8604.6 | 9298.7 |  | 7144.2
Wool top exports | 152.3 | 129.3 | 131.9 |  | 192.4
Total since January 1 | 1761.2 | 1890.5 | 2022.4 |  | 921.9
Mohair exports, clean | 53.1 | 62.5 | 29.5 |  | 35
Total since January 1 | 622.6 | 685.1 | 714.6 |  | 452
1/  Estimated by USDA.
Sources: USDA, Farm Service Agency; USDA, Foreign Agricultural Service,
U.S. Export Sales; U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update: 2/12/14.
Spreadsheet: 32a3c4fc-73bb-4d7e-bd9a-ab1541a41aca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table S3. Details of somatic alterations in KEAP1 in normal or tumor
 |  | derived lung cell lines.
 | Cell line Name/No. | Pathology | Tumor Derived | Normal Derived | DNA change | Amino acid change | LOH status ([NAME] center database)
 | NHBE | N.D. | N.A. | Yes | WT |  | No Information
 | BEAS2B | N.D. | N.A. | Yes | WT |  | No Information
 | HBE4 | N.D. | N.A. | Yes | WT |  | No Information
 | NL20 | N.D. | N.A. | Yes | WT |  | No Information
 | A549 | Adenocarcinoma | Yes | N.A. | G-T transversion | G-C | Complete Loss
 | H838 | Adenocarcinoma | Yes | N.A. | G-T transversion | Stop codon | Complete Loss
 | H1435 | Adenocarcinoma | Yes | N.A. | G-T transversion | L-R | No Information
 | H460 | Large Cell | Yes | N.A. | G-C transversion | D-H | Complete Loss
 | H1395 | Adenocarcinoma | Yes | N.A. | G-A transition | G-S | Complete Loss
 | H1993 | Adenocarcinoma | Yes | N.A. | G-A transition | G-S | Complete Loss
 | H23 | NSCLC | Yes | N.A. | WT |  | Partial loss
 | H1666 | Bronchioloalveolar | Yes | N.A. | WT |  | No loss
 | H358 | Bronchioloalveolar | Yes | N.A. | WT |  | Partial loss
 | H1299 | Large Cell | Yes | N.A. | WT |  | Complete Loss
 | H292 | Mucoepidermoid | Yes | N.A. | WT |  | No information
 | H1703 | Adenocarcinoma | Yes | N.A. | WT |  | Complete Loss
 | N.A, Not Available; N.D., Not Determined
Spreadsheet: 31501d1227347107-show-contents-of-vertical-cells-in-horizontal-cells-question-1-
Sheet: Sheet6

DATE | SOURCE | ACCOUNT CODE | [NAME] | DR | CR
2008-05-01 00:00:00 | STANDARD | 724005 | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 4362 | 4362
 |  |  | YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
 |  |  | ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ
 |  |  | KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
 |  |  | LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
 |  |  | MMMMMMMMMMMMMMMMMMMMMM
 |  |  | [NAME]
2008-04-01 00:00:00 | STANDARD | 723008 | AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA | 1200
 |  |  | BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
2008-04-01 00:00:00 | STANDARD | 725002 | [NAME] | 2920
 |  |  | PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP
 |  |  | UUUUUUUUUUUUUUUUUUUUUUUUUUU
 |  |  | OOOOOOOOOOOOOOOOOOOOOOOOOOO
2008-04-01 00:00:00 | STANDARD | 727009 | FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF | 9833.4
 |  |  | SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
 |  |  | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
2008-04-01 00:00:00 | STANDARD | 729002 | RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR | 11150
 |  |  | TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
2008-04-01 00:00:00 | STANDARD | 735001 | receipt: 0302 - DOC SEQ: 20080-9641 | 1625
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | hibitions.Special Event Expenses.QM Fi
2008-04-01 00:00:00 | STANDARD | 777420 | payment: 0071/08 - DOC SEQ: | 1200 | 1200
 |  |  | 200809638 - DESC: LANYARDS FORQMDI
 |  |  | hibitions.Gifts.QM First International
2008-04-01 00:00:00 | STANDARD | 735001 | Invoice: 0302 - DOC SEQ: 20080-9641 | 1625 | 1625
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | Vendor: Dddddddddd
2008-04-01 00:00:00 | STANDARD | 735500 | Invoice: 0302 - DOC SEQ: 20080-9641 | 100 | 100
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | Vendor: Dkhjhjghjgjh
2008-04-30 00:00:00 | GL | 721001 | GL: PAYROLL | 1200
 |  |  | HHDFSHFS
 |  |  | P[IKJOIJKJOIJisaioi0
Spreadsheet: 774402d1648459062-nested-if-statements-multiple-if-statements-v2
Sheet: C&DC Units

 | Unit Name | Cost Center
 | [NAME] | Housing & Site Management
 | CCOE-Architecture | Multi Cloud Services & Orchestration
 | Central Cloud AWS LZ | Multi Cloud Services & Orchestration
 | Central Cloud Azure LZ | Multi Cloud Services & Orchestration
 | Central Cloud GCP LZ | Multi Cloud Services & Orchestration
 | Central Cloud Shared-Services | Multi Cloud Services & Orchestration
 | OPS-Backup-Engineering | Datacenter & Edge Computing
 | OPS-Backup-Operations | Datacenter & Edge Computing
 | OPS-Compute-Architecture | Datacenter & Edge Computing
 | OPS-DB-Architecture | Datacenter & Edge Computing
 | OPS-DB-Engineering | Datacenter & Edge Computing
 | OPS-DB-Operations | Datacenter & Edge Computing
 | OPS-DCN-Architecture | Central IP-Management
 | OPS-DCN-Engineering
 | OPS-DCN-Operations
 | OPS-Firewall-Architecture-Engineering | Central IP-Management
 | OPS-Firewall-Architecture-Operations | Central IP-Management
 | OPS-Firewall-Operations | Central IP-Management
 | OPS-Housing-Operations | Datacenter & Edge Computing?
 | OPS-ISPE-Architecture | Central IP-Management
 | OPS-ISPE-Engineering | Central IP-Management
 | OPS-ISPE-Operations | Central IP-Management
 | OPS-Network-Services-Architecture | Datacenter & Edge Computing
 | OPS-Network-Services-Engineering | Datacenter & Edge Computing
 | OPS-Network-Services-Operations | Datacenter & Edge Computing
 | OPS-PL-Infra | Datacenter & Edge Computing
 | OPS-Private-Cloud-Architecture | Datacenter & Edge Computing
 | OPS-Private-Cloud-Engineering | Datacenter & Edge Computing
 | OPS-Private-Cloud-Operations | Datacenter & Edge Computing
 | OPS-Security-Inf-Engineering | Datacenter & Edge Computing
 | OPS-Security-Inf-Operations | Datacenter & Edge Computing
 | OPS-Server-Engineering | Datacenter & Edge Computing
 | OPS-Server-Operations | Datacenter & Edge Computing
 | OPS-Tool-Engineering | Datacenter & Edge Computing
 | OPS-Tools-Operations | Datacenter & Edge Computing
 | OPS-Housing-Engineering | Housing & Site Management
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: ReferenceUSA

ReferenceUSA
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
ReferenceUSA
Sessions | 122 | 119 | 109 | 102 | 127 | 101 | 107 | 227 | 254 | 253 | 89 | 79
Searches | 241 | 325 | 278 | 271 | 250 | 321 | 316 | 490 | 850 | 626 | 319 | 196 |  | 4792
Residential Searches | 35 |  | 45 | 55 | 41 | 77 |  | 79 | 88 | 112 | 62 | 43
Business Searches | 206 |  |  |  | 209 | 244 |  | 411 | 762 | 514 | 257 | 153
Spreadsheet: 54148d1254167741-formula-to-calulate-for-seperate-categories-no-child-left-behind-percentage
Sheet: Sheet1

Monitoring Student Progress 5 |  |  |  |  |  | Sunshine State Standards Benchmarks | 3.1.6.3. Use context clues for meaning | 3.1.7.4  Identify Cause and Effect | 3.2.1.2. Identify story elements | 3.1.7.3.  Determines ideas, including main ideas/ details, inferences, order of events | 3.1.7.3.  Determines ideas, including main ideas/ details, inferences, order of events | 3.1.6.8.  Use antonyms, synonyms, homephones, homegraphs for meaning | 3.1.7.3.  Determines ideas, including main ideas/ details, inferences, order of events | 3.2.2.1. Explain purpose of text features | 3.1.7.3.  Determines ideas, including main ideas/ details, inferences, order of events | 3.1.7.7. Compare/contrast topics/story elements in two texts
 | Race | SWD | F/R | ELL |  | Question | 1 D | 2 G | 3 C | 4 G | 5 | 6 | 7 | 8 | 9 | 10 | 12
 |  |  |  |  |  | Type | MC | MC | MC | MC | SA | MC | MC | MC | MC | SA | Student Average | Total Points
Student Name |  |  |  |  |  | Points | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2
Student 1 | W | Y | F |  |  |  | 0 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 0.6666666666666666 | 8
Student 2 | B |  | F |  |  |  | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 0.9166666666666666 | 11
Student 3 | W | Y |  |  |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | 2 | 0.6666666666666666 | 8
Student 4 | B |  | F | Y |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 0.75 | 9
Student 5 | H | Y |  |  |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0.6666666666666666 | 8
Student 6 | I |  | F | Y |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | 2 | 0.6666666666666666 | 8
Student 7 | A | Y | R |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 0.75 | 9
Student 8 | B |  | R |  |  |  | 1 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 1 | 0 | 0.6666666666666666 | 8
Student 9 | H |  | R | Y |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | 2 | 0.6666666666666666 | 8
Student 10 | I | Y | F |  |  |  | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 0.9166666666666666 | 11
Student 11 | W |  |  | Y |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 0 | 0 | 0.5833333333333334 | 7
Student 12 | W | Y | F |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 0.75 | 9
Student 13 | A |  |  |  |  |  | 1 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 1 | 0 | 0.6666666666666666 | 8
Student 14 | A | Y | R | Y |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  | 2 | 0.6666666666666666 | 8
Student 15 | B |  | F |  |  |  | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 0.9166666666666666 | 11
Student 16 | H | Y |  | Y |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 0 | 0 | 0.5833333333333334 | 7
Student 17 | W |  |  |  |  |  | 1 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 1 | 0 | 0.6666666666666666 | 8
Item Average |  |  |  |  |  |  | 0.7058823529411765 | 0.7647058823529411 | 0.8235294117647058 | 1 | 0.7272727272727273 | 0.9411764705882353 | 0.8235294117647058 | 1 | 0.8461538461538461 | 0.4705882352941176 | 0.8102838338132455
 | Percent by each Race |  | Percnet Only |  | Percnet Only |  | Percnet Only
 | Race | % | SWD | % | F/R | % | ELL | %
 | W
 | B
 | H
 | I
 | A
Spreadsheet: drew_fossum__8711__redrock n
Sheet: ESTIMATED RETURN

 |  |  |  |  |  |  |  |  |  |  |  | Exhibit N
 |  |  |  |  |  |  |  |  |  |  |  | Page 5 of  7
Estimated   Return
Line
No. |  | Description |  | Year   1 |  | Year  2 |  | Year  3 |  | Year  4 |  | Year  5 |  | Year  6 |  | Year  7 |  | Year  8 |  | Year  9 |  | Year  10
 |  |  |  | -1 |  | -2 |  | -3 |  | -4 |  | -5 |  | -6 |  | -7 |  | -8 |  | -9 |  | -10
1 |  | Plant
 |  | Less:
 |  | Accumulated Provision for
2 |  | Depreciation and Amort.
 |  | Accumulated Deferred
3 |  | Income Taxes
4 |  | Total Rate Base
 |  | Total Rate of
5 |  | Return  @ 10.29%        1/
6 |  | Return on Equity
7 |  | Return on Debt
8 |  | Total  Return on Rate Base
 |  | 1/  Rate of Return of 10.29% is Transwestern's settlement rate filed in its RP93-34 rate case.
Spreadsheet: 823638d1680066380-using-let-to-collate-data-and-sorting-data-based-off-date-column-excel-help-8
Sheet: Sheet1

 | Name | Position | State | Clinic | Hiring Manger | Entity | Employment Type | Commencement Date |  | 1 Month Check In | 3 Month Check In | 5 Month Check In | 6 Month Review |  | Next Update | 1 Month Check In | 3 Month Check In | 5 Month Check In | 6 Month Review |  |  |  |  |  | yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no |  |  |  |  |  | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | yes | yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no | Also once data is in the 1 sheet can I filter on date and then if the cells move around will the data in Q:T also move with it or no because one is collated from another spreadsheet and one is in the current sheet?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | no | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | yes | no | no
 | ^^^^^
 | [NAME] to sort data on [NAME] but needs to be only the values with TRUE and sorted by commencment date (some dates have "-")
Spreadsheet: 296fcbee-652f-41f6-8785-65d94d8461e7
Sheet: Sheet1

Clerkship Sessions Schedule - Block 3 | Unnamed: 1 | Unnamed: 2
Week 1 | Orientation | Monday, 9/29/2014 - Burnette Womack Clinical Skills Lab
Check "Orientation" on Clerkship website for times | Orientation to the logistics of the clerkship and preparation for the CARE assignment (TBL session).
 | Lunch
 | MSK and Procedures workshop. (wear or bring clothes to allow you to practice musculoskeletal exams on each other:  shorts and T shirts).
 | Adjourn
Week 2 |  | WEDNESDAY, 10/8/2014, Fam Med Building, Room 284
12:00:00 | Guideline Discussions | [NAME], MD
01:45:00 | Break
02:00:00 | Video Review | [NAME], MD
03:30:00 | Adjourn
Week 3 |  | THURSDAY, 10/16/2014, Fam Med Building, Room 238/239
08:00:00 | Working With Registries | [NAME], MD
10:00:00 | Review CARE Assignment | [NAME], MD
10:30:00 | Pharmacy Talk | [NAME], PharmD
11:30:00 | Individual Feedback | [NAME], MD (Kelly's office, Room 218)
 |  | 11:30 - Student 1; 11:45 - Student 2; 12:00 - Student 3; 12:15 - Student 4; 12:30 - Student 5; 12:45 - Student 6
Week 4 |  | FRIDAY, 10/24/2014 - Fam Med Building, Room 234
08:00:00 | [NAME] (OPE) | [NAME], MD, MPH
 |  | Students 4-6
10:30:00 | [NAME] (OPE) | [NAME], MD, MPH
 |  | Students 1-3
01:00:00 | Adjourn
Week 5 |  | FRIDAY, 10/31/2014 - Fam Med Building, Room 238/239
08:00:00 | Group Discussion-Share key components and reflections from Consultation notes | [NAME], MD
11:00:00 | Adjourn
Spreadsheet: 830336d1684860115-formula-to-get-the-number-of-months-between-two-dates-but-round-up-or-down-accordingly-date-examples
Sheet: Scenarios

Scenario 1: Two whole months
Date 1 | 2020-01-25 00:00:00
Date 2 | 2020-03-25 00:00:00
Step 1: Get whole month difference
Step 2: Calculate the date that many months after date 1
Step 3: Subtract step 2 from the ending date
Step 4a: Whenever step 3 is 14 or less, add 0
Step 4b: Whenever step 3 is 16 or greater, add1
Step 4c: Whenever step 3 is 15, check the month of end date and, if it is 2 then add 1
Step 5a: Add step 4a function to the result of step 1
Step 5b: Add step 4b function to the result of step 1
Step 5c: Add step 4c function to the result of step 1
Scenario 2: February with 14 days
Date 1 | 2019-12-08 00:00:00
Date 2 | 2020-02-22 00:00:00
Step 1: Get whole month difference
Step 2: Calculate the date that many months after date 1
Step 3: Subtract step 2 from the ending date
Step 4a: Whenever step 3 is 14 or less, add 0
Step 4b: Whenever step 3 is 16 or greater, add1
Step 4c: Whenever step 3 is 15, check the month of end date and, if it is 2 then add 1
Step 5a: Add step 4a function to the result of step 1
Step 5b: Add step 4b function to the result of step 1
Step 5c: Add step 4c function to the result of step 1
Scenario 3: February with 15 days
Date 1 | 2019-12-07 00:00:00
Date 2 | 2020-02-22 00:00:00
Step 1: Get whole month difference
Step 2: Calculate the date that many months after date 1
Step 3: Subtract step 2 from the ending date
Step 4a: Whenever step 3 is 14 or less, add 0
Step 4b: Whenever step 3 is 16 or greater, add1
Step 4c: Whenever step 3 is 15, check the month of end date and, if it is 2 then add 1
Step 5a: Add step 4a function to the result of step 1
Step 5b: Add step 4b function to the result of step 1
Step 5c: Add step 4c function to the result of step 1
Scenario 4: Non-February with 15 days
Date 1 | 2020-06-10 00:00:00
Date 2 | 2020-08-25 00:00:00
Step 1: Get whole month difference
Step 2: Calculate the date that many months after date 1
Step 3: Subtract step 2 from the ending date
Step 4a: Whenever step 3 is 14 or less, add 0
Step 4b: Whenever step 3 is 16 or greater, add1
Step 4c: Whenever step 3 is 15, check the month of end date and, if it is 2 then add 1
Step 5a: Add step 4a function to the result of step 1
Step 5b: Add step 4b function to the result of step 1
Step 5c: Add step 4c function to the result of step 1
Scenario 5: Non-February with 16 days
Date 1 | 2020-06-09 00:00:00
Date 2 | 2020-08-25 00:00:00
Step 1: Get whole month difference
Step 2: Calculate the date that many months after date 1
Step 3: Subtract step 2 from the ending date
Step 4a: Whenever step 3 is 14 or less, add 0
Step 4b: Whenever step 3 is 16 or greater, add1
Step 4c: Whenever step 3 is 15, check the month of end date and, if it is 2 then add 1
Step 5a: Add step 4a function to the result of step 1
Step 5b: Add step 4b function to the result of step 1
Step 5c: Add step 4c function to the result of step 1
Spreadsheet: rick_buy__32829__SS Participation
Sheet: nov. 2-4

Friday 11/2 | Saturday 11/3 | Sunday 11/4
Dinner 6pm-9pm: | Breakfast/speaker 7:45am-8:45am: | Brunch 10am-1pm
[NAME] |  | Program staff
[NAME]  x39521
[NAME] | Interviews 9am-12pm:
have 3 need 17 | [NAME]
 | [NAME]  x31667 / 1st choice
 | [NAME]x30397
 | Llyod Will
 | [NAME]
 | [NAME]
 | [NAME]  x67351
 | [NAME]  x35654
 | [NAME]  x53311
 | [NAME]  x39521
Any Date: | [NAME]
[NAME] | have 11 need 50
intv/dinner
[NAME] | Lunch/speaker 12pm-1:30pm:
[NAME]
[NAME]
[NAME]  x51688
[NAME]x34256 | EB Tour So. & No. 1:45pm-
[NAME] | Program staff
[NAME]  x31915
[NAME]
[NAME]  x30594 | Dinner 6pm-9pm
 | Current associates
 | [NAME]
 | [NAME]
 | [NAME]  x39521
Spreadsheet: 121600d1316188036-help-on-designing-a-workbook-wcb-sandbox2
Sheet: 1

Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 1
Zone 1 | 46 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 1 | 54 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 1 | 67 | P | 11 | 5.5 | Shaun G | [NAME]
Zone 1 | 4A | P | 11 | 5.5 | Shaun G | [NAME]
Zone 1 | 18 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 6 | P | 11 | 5.5 | Shaun G | [NAME]
Zone 2 | 21 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 48 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 12 | L | 7.65 | 3.825 | Shaun G | [NAME]
Zone 2 | 62 | L | 7.65 | 3.825 | Shaun G | [NAME]
Total Cleans | 10 |  | 86.55000000000001 | 43.27500000000001 | 43.27500000000001 | 43.27500000000001
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 2
Zone 3 | 101 | L |  | 0 | [NAME] | [NAME]
Zone 3 | 101A | P |  | 0 | [NAME] | [NAME]
Zone 3 | 67 | L |  | 0 | [NAME] | [NAME]
Zone 3 | 70 | L |  | 0 | [NAME] | [NAME]
Zone 3 | 71 | L |  | 0 | [NAME] | [NAME]
Zone 4 | 73 | L |  | 0 | [NAME] | [NAME]
Zone 4 | 76 | L |  | 0 | [NAME] | [NAME]
Zone 4 | 80 | L |  | 0 | [NAME] | [NAME]
Zone 4 | 82 | L |  | 0 | [NAME] | [NAME]
Zone 4 | 83 | L |  | 0 | [NAME] | [NAME]
Total Cleans | 10 |  | 0 | 0 | 0 | 0
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 3
Zone 5 | 83a | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 5 | 88 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 5 | 95 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 5 | 97 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 5 | 10 | P |  | 0 | Elaine S | Kylie B | Sonia B
Zone 5 | 11 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 6 | 44 | P |  | 0 | Elaine S | Kylie B | Sonia B
Zone 6 | 5 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 6 | 1 | L |  | 0 | Elaine S | Kylie B | Sonia B
Zone 6 | 4 | L |  | 0 | Elaine S | Kylie B | Sonia B
Total Cleans | 10 |  | 0 | 0 | 0 | 0 | 0
Area | Unit | Type | Unit Price | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 4
Zone 6 | 37a | L |  | 0 | [NAME] | [NAME]
Zone 6 | 40a | L |  | 3.83 | [NAME] | [NAME]
Zone 6 | 1 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 56 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 57 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 58 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 59 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 60 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 12 | L |  | 3.83 | [NAME] | [NAME]
Zone 7 | 5 | L |  | 3.83 | [NAME] | [NAME]
Total Cleans | 10 |  | 0 | 34.46999999999999 | 34.46999999999999 | 34.46999999999999
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: Huntington

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Huntington Hills Community Association |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 1361
 | February | 0 | 994
 | March | 0 | 1077
 | April | 0 | 844
 | May | 0 | 235
 | June | 0 | 131
 | July | 0 | 47
 | August | 0 | 98
 | September | 0 | 574
 | October | 0 | 769
 | November | 0 | 1025
 | December | 0 | 1180
 | TOTAL: