tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123748d1317833754-conditional-formatting-book1
Sheet: Sheet1

 | A | B | C | D | % |  |  | 1. Cell value >59
Student 1 | 86 | 54 | 72 | 212 | 71 |  |  | format green
Student 2 | 56 | 57 | 52 | 165 | 55 |  |  | 2. determine with this formula
Student 3 | 40 | 34 | 64 | 138 | 46
Student 4 | 94 | 76 | 94 | 264 | 88 |  |  | format red
Student 5 | 94 | 46 | 70 | 210 | 70
Student 6 | 80 | 28 | 58 | 166 | 55
Student 7 | 100 | 69 | 100 | 269 | 90
Spreadsheet: 1a618805-ab40-4bbe-ba80-543380ba90a9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Human Services: Personal Care Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Personal Care Services Pathway of the Human Services Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on
a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an
educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Personal Care Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Barber ►Companion ►Cosmetologist, [NAME] and                .   Hairstylist ►Electrologist ►Electrolysis Technician ►Embalmer ►Esthetician ►Exercise Physiologist ►Funeral Attendant ►Funeral Director ►Home Care Aide ►Massage Therapist ►Mortician ►Nail Technician, Manicurist and                    .   Pedicurist ►Personal Aide ►Personal Fitness Trainer ►Shampooer ►Skin Care Specialist ►Spa Attendant
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 221696d1363641085-multiple-conditions-with-horizontal-data-example
Sheet: Sheet1

Jan | Store A
Feb | Store B
Mar
Store | Store A |  | Data Validation
Month | Feb
Employee | Production
[NAME] | 18
[NAME] | 7
[NAME] | 25
[NAME] | 14
Raw Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store
 |  | Production |  |  |  |  |  |  |  |  |  |  |  |  | Employee | Data | Store A | Store B | Grand Total
Store | Employee | Jan | Feb | Mar | April | Mar | June | July | Sept | Aug | Oct | Nov | Dec |  | [NAME] | Sum of Jan | 8 | 12 | 20
Store A | [NAME] | 5 | 18 | 8 |  |  |  |  |  |  |  |  |  |  |  | Sum of Feb | 14 | 7 | 21
Store A | [NAME] | 6 | 7 | 12 |  |  |  |  |  |  |  |  |  |  |  | Sum of Mar | 13 | 78 | 91
Store A | [NAME] | 7 | 25 | 5 |  |  |  |  |  |  |  |  |  |  | [NAME] | Sum of Jan | 5 | 9 | 14
Store A | [NAME] | 8 | 14 | 13 |  |  |  |  |  |  |  |  |  |  |  | Sum of Feb | 18 | 7 | 25
Store B | [NAME] | 9 | 7 | 21 |  |  |  |  |  |  |  |  |  |  |  | Sum of Mar | 8 | 21 | 29
Store B | [NAME] | 10 | 14 | 8 |  |  |  |  |  |  |  |  |  |  | [NAME] | Sum of Jan | 7 | 11 | 18
Store B | [NAME] | 11 | 8 | 6 |  |  |  |  |  |  |  |  |  |  |  | Sum of Feb | 25 | 8 | 33
Store B | [NAME] | 12 | 7 | 78 |  |  |  |  |  |  |  |  |  |  |  | Sum of Mar | 5 | 6 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sum of Jan | 6 | 10 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum of Feb | 7 | 14 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum of Mar | 12 | 8 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sum of Jan |  | 26 | 42 | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sum of Feb |  | 64 | 36 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sum of Mar |  | 38 | 113 | 151
Spreadsheet: 680864d1591226995-retrieve-data-from-column-while-skipping-blanks-ef-lookup
Sheet: Sheet1

 | NAME | [NAME] | ADDRESS | CITY | PHONE
 | [NAME] | [EMAIL] | 14510 124th ave, #A6 | Kirkland, WA 98034
 | [NAME] | [EMAIL] | 14517 124th ave, #A6 | Kirkland, WA 98041 | 4259886346
 | [NAME] |  | 14524 124th ave, #A6 | Kirkland, WA 98048 |  |  |  |  | lookup
 | [NAME] |  | 14531 124th ave, #A6 | Kirkland, WA 98055 | 3066598794 |  |  | Person: | [NAME] | lookup value
 | [NAME] |  | 14511 124th ave, #A6 | Kirkland, WA 98035 | 3543265976
 | [NAME] | [EMAIL]
 | [NAME] |  | 14525 124th ave, #A6 | Kirkland, WA 98049 | 3531546467
 | [NAME] | [EMAIL] | 14532 124th ave, #A6 | Kirkland, WA 98056 | 6431113313
 | [NAME] | [EMAIL]
 | [NAME] |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | [NAME] | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 4679135648 |  |  |  | retrieve
 | [NAME] |  |  |  |  |  |  | email: | [EMAIL]
 | [NAME] | [EMAIL] | 14513 124th ave, #A6 | Kirkland, WA 98037 |  |  |  | address | 14513 124th ave, #A6
 | [NAME] |  |  |  | 8979874636 |  |  | city | Kirkland, WA 98037
 | [NAME] | [EMAIL] | 14527 124th ave, #A6 | Kirkland, WA 98051 | 6565465413 |  |  | phone | 8979874636
 | Brooklyn Odonnell |  | 14514 124th ave, #A6 | Kirkland, WA 98038
 | Brooklyn Odonnell | [EMAIL] | 14521 124th ave, #A6 | Kirkland, WA 98045 | 5646546544
 | Brooklyn Odonnell | [EMAIL] | 14528 124th ave, #A6 | Kirkland, WA 98052
 | [NAME] | [EMAIL]
 | [NAME] |  | 14523 124th ave, #A6 | Kirkland, WA 98047 | 5647891445
 | [NAME] | [EMAIL]
 | [NAME] |  | 14516 124th ave, #A6 | Kirkland, WA 98040
 | [NAME] | [EMAIL] | 14523 124th ave, #A6 | Kirkland, WA 98047 | 6548931464
 | [NAME] | [NAME] | 14530 124th ave, #A6 | Kirkland, WA 98054
Spreadsheet: 767792d1644637752-eight-extend-to-nine-words-eight-extends
Sheet: Sheet1

AROINTED |  |  | WAREHOUSE | Y
[NAME] |  |  | RODENTIAL
ORDINATE |  |  | DERATIONS
[NAME] |  |  | NOTARISED
ORIENTAL |  |  | ORDINATES
RELATION |  |  | ORIENTALS
TAILERON |  |  | RELATIONS
ANOESTRI |  |  | SEROTINAL
ARSONITE |  |  | TAILERONS
NOTAIRES |  |  | TENSORIAL
WAREHOUS | Y |  | OUTLINEAR
Spreadsheet: f9f26ded-e416-4d31-93f9-4a8ff604cefe
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (7 [NAME]):
 | 2 Analytik 2.5 Zubehör für Spektroskope 2.5.4 Monochromatoren
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Alliance Instruments - AMS France Unity Scientific | Frankreich | Frepillon | 95740 | A1.406
2 | HORIBA Jobin Yvon GmbH | Deutschland | Bensheim | 64625 | A2.213/314
3 | J&M Analytik AG | Deutschland | [NAME] | 73457 | A2.550
4 | Laser 2000 GmbH | Deutschland | Weßling | 82234 | A2.303
5 | Molecular Devices (Germany) GmbH | Deutschland | Biberach an der Riss | 88400 | A3.230A
6 | Optical Building Blocks Corporation | USA | Birmingham | NJ 08011 | A1.441
7 | Unity Scientific GmbH | Deutschland | [NAME] | 40549 | A1.406
Spreadsheet: 85280d1285317082-timeline-formula-timevalues
Sheet: States

Name | Site | Start1 | End1
 |  |  |  | 7:30:00 | 7:45:00 | 8:00:00 | 8:15:00 | 8:30:00 | 8:45:00 | 9:00:00 | 9:15:00 | 9:30:00 | 9:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 |  |  |  | Name
Humpty dumpty | Wait | 8:01:00 | 8:03:00
Humpty dumpty | Call | 8:03:00 | 8:09:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adrian MANN
Humpty dumpty | Call | 8:13:00 | 8:19:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Humpty dumpty | Wait | 8:19:00 | 8:21:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending January 18, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: Staff Training

STAFF TRAINING
Include travel related costs for attendance at staff training as well as any costs incurred to conduct training.
Attach copies of training report forms and agendas when required training is held. The records will maintained in your organization's management plan.
Examples of training supplies include paper, brochures, folders, handouts, etc.
Date(s) of Training | Title and Description of Training Session |  | Facility Rental | Training Supplies | Equipment Costs | Registation Fees | Milage Cost | Lodging | Meals | Other | Total Cost Staff Training | % Allocated to CACFP | Total  Cost to CACFP
 |  |  |  |  |  |  |  |  | Total Staff Training
Spreadsheet: 32949d1229108098-counting-occurance-of-particular-digit-count-numbers
Sheet: Sheet1

 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
0909 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
1234 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
4556 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 0 | 0 | 0
4557 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 0
4558 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 0
4559 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 1
4560 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0
4561 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0
3400 | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
0000 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 3d19932b-b7a3-427e-92da-3e411afd1b1b
Sheet: AT

 | Allocation Table
 | Headworks last approved:
 | Allocation Table updated:
 | Permits last  modified:
POTW=>
NPDES#=>
 |  |  |  |  |  |  |  | FLOW
 |  | Industry |  | Type | Renewal | Modification | Date | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits |  | Permit Limits
IUP | INDUSTRY NAMES | Permit | Pipe | of | Effective | Effective | Permit |  |  | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load | Conc. | Load
Count | (please list alphabeticly) | number | number | Industry | Date | Date | Expires | MGD | gal/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day | mg/l | lbs/day
1
2
3
4
5
6
7
8
9
10
 |  | Column Totals =>
 |  | Basis=> |  |  |  |  |  | NPDES
 |  | MAHL from HWA (lbs/day) => |  |  |  |  | NPDES Permitted Flow=>
 |  | Uncontrollable Loading (lbs/day) =>
 |  | Total Allowable for Industry (MAIL) (lbs/day) =>
 |  | Total Permitted to Industry (lbs/day) =>
 |  | MAIL left (lbs/day) =>
 |  | [NAME]. Ind. (MAIL) still available (%) =>
 |  | Percent MAHL still available (%) =>
 |  | 5 Percent MAHL (lbs/day) =>
Spreadsheet: 690094d1596866373-filtering-subaccount-in-accounting-software-filtering-subaccounts
Sheet: accounts

ეს ბლანქზე უნდა მოფილტრო და საბოლოო ანგარიშები ამოვა.
Accounts |  |  | Type |  | Description | Closing balance | [NAME]
1000 |  |  | აქტ |  | [NAME] | 1104840.05
1100 |  |  | აქტ |  | ნაღდი ფული სალაროში | 7116.72
1110 |  | 1 | აქტ |  | ნაღდი ფული ეროვნულ ვალუტაში | 7116.72
1200 |  |  | აქტ |  | ფული საბანკო ანგარიშებზე | 34703.46
1210 |  |  | აქტ |  | ეროვნული ვალუტა რეზიდენტ ბანკში | 24373.54
1210 2 |  | 1 | აქტ |  | ბანკი ქართუ | 19373.54
1210 3 |  | 1 | აქტ |  | ბიზნეს ბარათი ქართუ | 0
1210 1 |  | 1 | აქტ |  | საქართველოს ბანკი | 5000
1220 |  |  | აქტ |  | უცხოური ვალუტა რეზიდენტ ბანკში | 10329.92
1220 2 |  | 1 | აქტ |  | ბანკი ქართუ EUR | 0
1220 3 |  | 1 | აქტ |  | ბანქი ქართუს ბიზნეს ბარათი USD | 0
1220 6 |  | 1 | აქტ |  | ბიზნეს ბარათი EUR | 0
1220 1 |  | 1 | აქტ |  | ქართუ ბანკი USD | 10329.92
1400 |  |  | აქტ |  | მოკლევადიანი მოთხოვნები | 548383.37
1410 |  |  | აქტ |  | მოთხოვნები მიწოდებიდან და მომსახურებიდან | 529335.07
1410 1422 |  | 1 | აქტ |  | CITY AND CO LTD, 404398077 | 111
1410 1422 3 |  |  |  |  |  | 11 |  | This must be sub account of above give value
1410 14223 |  |  |  |  |  | 212 |  | But this does'not need to be selected, because after 2 there is no space, so this is different account.
1410 1399 |  | 1 | აქტ |  | [NAME] მალიბუ ფლაუერს, 405229015 | 2
Spreadsheet: 406ad0f3-4d27-4a87-b0de-21809d055909
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/30/2011 | Rifle | Alumni Match | All Day
10/15/2011 | Rifle | vs. Air Force (Lincoln, Neb.) | W, 4664-4587
10/16/2011 | Rifle | at Nebraska | W, 4667-4610
10/22/2011 | Rifle | ARMY | W, 4693-4637
10/29/2011 | Rifle | MEMPHIS | W, 4678-4616
10/30/2011 | Rifle | MURRAY STATE | W, 4688-4615
11/12/2011 | Rifle | OLE MISS | W, 4671-4646
01/14/2012 | Rifle | AKRON | W, 4691-4554
01/20/2012 | Rifle | ALASKA-FAIRBANKS | W, 4676-4626
01/22/2012 | Rifle | at Ohio State | W, 4680-4616
01/28/2012 | Rifle | at TCU | L, 4701-4669
02/03/2012 | Rifle | KENTUCKY | L, 4680-4650
[NAME] | Rifle | NC STATE | W, 4647-4577
02/18/2012 | Rifle | VMI ([NAME]) | W, 4678-4413 (m), 4326 (w)
[NAME] | Rifle | GARC Championships (Oxford, Miss.) | Second Place, 2315 (smallbore)
02/26/2012 | Rifle | GARC Championships (Oxford, Miss.) | First Place, 2366 (air rifle)
03/09/2012 | Rifle | [NAME] (Columbus, Ohio) | Eighth Place, 2297
03/10/2012 | Rifle | [NAME] (Columbus, Ohio) | Sixth Place, 4647
Spreadsheet: 128630d1321121742-graphing-an-automated-advanced-filter-paul-master-forecast-model-pivot-refresh-new-error
Sheet: Customer

 | Select a Product Group | Laminated |  |  | Cutomer Number
 | AND / OR |  |  |  | 2
 | Georgian
 | AND / OR
 | Spacer
 | AND / OR
 | Textured
 | [NAME]
 | Product Group | [NAME] | Spacer | Textured | Georgian | Price | Volume | Revenue |  |  | Product Group | Volume
 | Laminated | Annealed | Aluminium | No | No | 19 | 99 | 37 |  |  | EnergiKare | 0
 | Laminated | Annealed | Super | No | No | 90 | 77 | 19 |  |  | [NAME] | 0
 | Laminated | Annealed | Swiss | No | No | 89 | 72 | 2 |  |  | Triple Glazed | 0
 | Laminated | Annealed | TGI | No | No | 31 | 68 | 63 |  |  | Laminated | 869
 | Laminated | Annealed | Aluminium | Yes | No | 9 | 65 | 14 |  |  | Other | 0
 | Laminated | Annealed | Super | Yes | No | 58 | 90 | 72 |  |  | ST | 0
 | Laminated | Annealed | Swiss | Yes | No | 29 | 31 | 56 |  |  | [NAME] | 0
 | Laminated | Annealed | TGI | Yes | No | 36 | 45 | 90 |  |  | Volume | (All)
 | Laminated | Annealed | Aluminium | No | Yes | 29 | 43 | 88
 | Laminated | Annealed | Super | No | Yes | 79 | 12 | 67 |  |  | Sum of Volume
 | Laminated | Annealed | Swiss | No | Yes | 98 | 76 | 60 |  |  | Product Group | Spacer | Total
 | Laminated | Annealed | TGI | No | Yes | 34 | 78 | 23 |  |  | [NAME] | Aluminium | 27
 | Laminated | Annealed | Aluminium | Yes | Yes | 15 | 58 | 19 |  |  |  | Super | 30
 | Laminated | Annealed | Super | Yes | Yes | 64 | 23 | 77 |  |  |  | Swiss | 61
 | Laminated | Annealed | Swiss | Yes | Yes | 16 | 4 | 71 |  |  |  | TGI | 16
 | Laminated | Annealed | TGI | Yes | Yes | 12 | 28 | 29 |  |  | Conservatory Roof Total |  | 134
 |  |  |  |  |  |  |  |  |  |  | EnergiKare | Aluminium | 485
 |  |  |  |  |  |  |  |  |  |  |  | Super | 281
 |  |  |  |  |  |  |  |  |  |  |  | Swiss | 383
 |  |  |  |  |  |  |  |  |  |  |  | TGI | 425
 |  |  |  |  |  |  |  |  |  |  | EnergiKare Total |  | 1574
 |  |  |  |  |  |  |  |  |  |  | Laminated | Aluminium | 265
 |  |  |  |  |  |  |  |  |  |  |  | Super | 202
 |  |  |  |  |  |  |  |  |  |  |  | Swiss | 183
 |  |  |  |  |  |  |  |  |  |  |  | TGI | 219
 |  |  |  |  |  |  |  |  |  |  | Laminated Total |  | 869
 |  |  |  |  |  |  |  |  |  |  | Other | Aluminium | 453
 |  |  |  |  |  |  |  |  |  |  |  | Super | 390
 |  |  |  |  |  |  |  |  |  |  |  | Swiss | 281
 |  |  |  |  |  |  |  |  |  |  |  | TGI | 315
 |  |  |  |  |  |  |  |  |  |  | Other Total |  | 1439
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Aluminium | 333
 |  |  |  |  |  |  |  |  |  |  |  | Super | 533
 |  |  |  |  |  |  |  |  |  |  |  | Swiss | 404
 |  |  |  |  |  |  |  |  |  |  |  | TGI | 335
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1605
 |  |  |  |  |  |  |  |  |  |  | ST | No Spacer | 97
 |  |  |  |  |  |  |  |  |  |  | ST Total |  | 97
 |  |  |  |  |  |  |  |  |  |  | Triple Glazed | Aluminium | 295
 |  |  |  |  |  |  |  |  |  |  |  | Super | 483
 |  |  |  |  |  |  |  |  |  |  |  | Swiss | 407
 |  |  |  |  |  |  |  |  |  |  |  | TGI | 377
 |  |  |  |  |  |  |  |  |  |  | Triple Glazed Total |  | 1562
 |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 7280
Spreadsheet: 1364d387-3504-4681-a05e-076ee2ab9424
Sheet: Step 5 - Summary Review

 |  |  | - Enter in White Cells -
 |  |  |  |  |  | Step 5 - Summary Review
 |  |  |  |  |  | Review your budget vs. revenue
 |  |  |  |  |  | Determine shortfalls and make adjustments as necessary.
[NAME] |  |  | YEAR 0 | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5
SBB REVENUE
[NAME] (Offset)
GOB Offset |  |  | 0 | 0 | 0 | 0 | 0 | 0
School Consolidation (Offset)
Grants (Walton, CDE, Other) |  |  | 0
OTHER |  |  |  | 200000 | 200000 | 177623 | 170344 | 135504
TOTAL REVENUE
ADMINISTRATIVE FULL TIME STAFF
TEACHING FULL TIME STAFF
PRO-TECH FULL TIME STAFF
CLERICAL FULL TIME STAFF
FT ACCOUNTS TOTAL
PART TIME ACCOUNTS TOTAL
NON-SALARY BUDGET TOTAL
CAPITAL BUDGET TOTAL
DISTRIBUTED BUDGET TOTAL
REMAINING BALANCE TO DISTRIBUTE
Estimated Per Student Revenue - K-12 (K=.5) |  |  | NA
Estimated Subsidy Per Student - K-12 (K=.5) |  |  | NA
Estimated Total Cost Per Student - K-12 (K=.5) |  |  | NA
Estimated Total Cost Per Student at school - K-12 (K=.5) |  |  |  |  |  |  | 5331.26 | 5331.26
 |  |  | -240000 | -245288.875 | 26350.6754999999 | 126409.4262325 | 129923.9800948249 | 72218.86429577321
Spreadsheet: 81739d1281909386-header-image-white-stripe-on-the-left-and-right-side-of-document-during-printing-sheet3
Sheet: List1

fdsfAAAA
 | dsfsdf
 | sfsdf
 |  | dsf
 |  |  | asf
 |  |  | sd
 |  |  | f
 |  |  | sf
 |  |  | sf
 |  |  | sfd
 |  |  | fsd
 |  |  | s
 |  |  | sfds
 |  |  | s
 |  |  | fds
 |  |  | d
 |  |  | sdf
 |  |  | sdfsdA
 |  |  | sfdfds
 |  |  | dsf
 |  |  | sfdfds
 |  |  | sfdfds
 |  |  | sfdfds
 |  |  | sfdfds
 |  |  | sfdfds
 |  |  | sfdfdsQ
 |  |  | sfsfd
 |  |  | sfdfds
 |  |  | sd
 |  |  | sfdfds
CCC
poslednz
Spreadsheet: 753795d1635766565-use-functions-or-a-tool-like-goal-seek-solver-sample-workbook
Sheet: Sheet1

 | Payback Capacity |  |  |  |  |  |  | Variables
 | Year | 2021 | 2022 | 2023 | 2024 | 2025 |  | Revenu | 1000000
 |  |  |  |  |  |  |  | Costs | 800000
 | Revenu |  |  |  |  |  |  | g (Revenu) | 0.05
 | Costs |  |  |  |  |  |  | g (Costs) | 0.05
 | Gross Margin |  |  |  |  |  |  | Loans
 |  |  |  |  |  |  |  | Loan 1 | 400000
 | Repayment Loan 1 | 180000 | 190000 | 30000 |  |  |  | Loan 2 | 300000
 | [NAME] |  |  | 170500 | 129500 |  |  | Loan 3 | 200000
 | [NAME] |  |  |  | 82025 | 117975 |  | Total
 | Residual CF
 | Notes:
 | 1. Residual CF must be equal to or greater than €20,000.00.
 | 2. Repayment of Loan 1 has priority over Repayment of Loan 2, Repayment of Loan 2 has priority over Repayment of Loan 3.
 | 3. Repayment of loans must be maximized considering restriction of Note 1, i.e. no residual CF should be larger than €20,000.00 unless loans have been repaid entirely.
 | 4. The client should not be able to change any cell apart from those in the 'Variables' table and all calculations following such change should be automated.
 | 5. The problem I am facing is how to make these calculations automated and have the repayment of each loan be maximized automatically?
Spreadsheet: 744322d1629161769-quarterly-sum-the-values-with-interest-rate-test-39-qestion
Sheet: 검증

0.03 | CODE | AMOUNT | QUARTER | before_A | after_A | before_B | after_B |  | after_A | after_B
 | 3_2020 | 100 | 1
 | 3_2020 | 150 | 1
 | 3_2020 | 200 | 1
 | 3_2020 | 250 | 2
 | 3_2020 | 300 | 2
 | 3_2020 | 350 | 2
 | 3_2020 | 400 | 3
 | 3_2020 | 450 | 3
 | 3_2020 | 500 | 3
 | 3_2020 | 550 | 4
 | 3_2020 | 600 | 4
 | 3_2020 | 650 | 4
 | 3_2020 | 700 | 1
 | 3_2020 | 750 | 1
 | 3_2020 | 800 | 1
 | 3_2020 | 850 | 2
 | 3_2020 | 900 | 2
 | 3_2020 | 950 | 2
 | 3_2020 | 1000 | 3
 | 3_2020 | 1050 | 3
 | 3_2020 | 1100 | 3
 | 3_2020 | 1150 | 4
 | 3_2020 | 1200 | 4
 | 3_2020 | 1250 | 4
 | 3_2021 | 120 | 1
 | 3_2021 | 180 | 1
 | 3_2021 | 240 | 1
 | 3_2021 | 300 | 2
 | 3_2021 | 360 | 2
 | 3_2021 | 420 | 2
 | 3_2021 | 480 | 3
 | 3_2021 | 540 | 3
 | 3_2021 | 600 | 3
 | 3_2021 | 660 | 4
 | 3_2021 | 720 | 4
 | 3_2021 | 780 | 4
 | 3_2021 | 840 | 1
 | 3_2021 | 900 | 1
 | 3_2021 | 960 | 1
 | 3_2021 | 1020 | 2
 | 3_2021 | 1080 | 2
 | 3_2021 | 1140 | 2
 | 3_2021 | 1200 | 3
 | 3_2021 | 1260 | 3
 | 3_2021 | 1320 | 3
 | 3_2021 | 1380 | 4
 | 3_2021 | 1440 | 4
 | 3_2021 | 1500 | 4