tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67bbed64-404d-4cd5-871c-e65def2bbe4d
Sheet: Example 4.3

Calcuate the vapor pressure deficit using mean temperature minus saturation vaper pressure at dewpoint.
 | (es - ed) = es_Tavg - es_Td
 | (es - ed) = | saturation vapor pressure minus the actual vapor pressure
 | es_Tavg = | saturation vapor pressure at mean temperature
 | es_Td = | saturation vapor pressure at dewpoint.
Problem: | Find the vapor pressure deficit for [NAME] 17, 1993 at Piketon, OH.
Solution: | Part 1) Use the equation from Example 4.2 to find the saturation vapor pressure at the mean temperature.  Part 2) Find the average actual vapor pressure.
 | Tave = | 22.05 | C
 | es = exp [(16.78T-116.9)/(T+237.3)]
 | numerator
 | denomonator
 | es |  | kPa
 | Time | ed
 | 01:00:00 | 1.765
 | 02:00:00 | 1.708
 | 03:00:00 | 1.652
 | 04:00:00 | 1.613
 | 05:00:00 | 1.593
 | 06:00:00 | 1.51
 | 07:00:00 | 1.513
 | 08:00:00 | 1.638
 | 09:00:00 | 1.81
 | 10:00:00 | 1.988
 | 11:00:00 | 2.099
 | 12:00:00 | 2.199
 | 13:00:00 | 1.925
 | 14:00:00 | 1.996
 | 15:00:00 | 1.995
 | 16:00:00 | 2.026
 | 17:00:00 | 2.103
 | 18:00:00 | 2.139
 | 19:00:00 | 2.193
 | 20:00:00 | 2.424
 | 21:00:00 | 2.496
 | 22:00:00 | 2.42
 | 23:00:00 | 2.327
 | 1900-01-01 00:00:00 | 2.292
 | Average =
Spreadsheet: kate_symes__18417__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
 | 2000-12-09 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 187.04 | 810 | 148.98 | 1225
 | 2000-12-08 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 287.06 | 1430 | 175 | 390
 | 2000-12-07 00:00:00 |  | 312.11 | 2080 | 205.86 | 2776 | 246.51 | 172 | 138.05 | 519
 | 2000-12-06 00:00:00 |  | 267.18 | 2128 | 177.11 | 1344 | 260.08 | 529 | 151.35 | 911
 | 2000-12-05 00:00:00 |  | 237.02 | 2848 | 119.16 | 904 | 274.6 | 1057 | 172.84 | 1728
Spreadsheet: 599662d1543241715-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Team 3

Date | [NAME] |  |  |  | PI
 | Sickcall and Med Documentation
 | Infection, Asepsis, & Sterile Techniques
 | Medication Administration
 | Injections
 | Pharmacology
 | Venipuncture
 | EENT Primary Care
 | Respiratory Primary Care
 | Abdominal Primary Care
 | Orthopedic Primary Care
 | Basic Wound Primary Care
 | Skin Disease Primary Care
 | Primary Care Pre-Examination Review
 | Primary Care Exam
 | Intro to Battlefield Medicine
 | Battlefield Communication/ Documentation
 | Casualty Movement
 | Combat Medical Aid Bag
 | Combat Casualty Assessment
 | Control Bleeding
 | Airway Management
 | [NAME] Trauma
 | Shock
 | Vascular Access
 | Fieldcraft 1 Pre-Examination Review
 | Field Craft Exam
 | Head Injuries with Traumatic Brain Injuries
 | Ocular Injuries
 | Burns
 | [NAME]
 | Musculoskeletal Trauma
 | [NAME]
 | Field Craft 2 Exam
 | [NAME] Training
 | Casualty Triage
 | Suicide Prevention
 | [NAME] and Geneva Conv.
 | Environmental Threat
 | Fieldcraft 3 Pre-Examination Review
 | Field Craft Exam
2018-04-24 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
2018-04-25 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
2018-04-26 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 689325d1596302788-search-by-cell-address-array-all-results-not-only-1-sample
Sheet: MAIN

Material Description |  |  |  |  |  |  | TYPE IN BELOW
[NAME] |  |  |  |  |  | SEARCH | psen
M20 08233
PSEN CS31
ADAPTER |  |  |  |  |  | RESULT 1 DESCRIPTION -->
PSEN CS33 |  |  |  |  |  | RESULT 2 DESCRIPTION -->
 |  |  |  |  |  | RESULT 3 DESCRIPTION -->
Spreadsheet: 598644d1542637711-most-frequent-word-is-not-working-most-frequent-word
Sheet: Sheet2

case 2 |  |  |  |  |  |  |  |  |  |  |  |  | my needs:
z | 0
z | 0
z | 0
z | 0
a | 0.2 |  | The best result should be b, because if would sum these percentages, then b% is closer to 0 |  |  |  |  |  |  |  |  |  | the best result in terms of frequency: |  |  |  | a | (in fact it is "a" and "b" but excel will show first result which is true to conditions
b | 0.1 |  |  |  |  |  |  |  |  |  |  |  | the best result in terms of % |  |  |  | b | (10%+5%+8%) is closer to 0 than (20%, 30%, 25%)
c | 0.3
d | 0.33
e | 0.35
a | 0.3
a | 0.25 |  |  |  |  |  |  |  |  |  |  |  | FORMULA/ RESULT
b | 0.05
b | 0.08 |  |  |  |  |  |  |  |  |  |  |  | It should return "b" not "a"
f | 0
f | 0
f | 0
Spreadsheet: 64361d1265229229-multiple-values-for-a-cell-purchase
Sheet: SUB COUNT

Verizon FiOS - Buffalo
Sub Count as of 12/31/09
Zip Code | Sub Count | CD
14010 | 3 | 27
14051 | 982 | 26
14068 | 529 | 26
14075 | 4657 | 27
14085 | 185 | 27
14127 | 3844 | 27
14150 | 1342 | 28
14170 | 48 | 27
14210 | 41 | 27,28
14216 | 1 | 27,28
14217 | 1207 | 28
14218 | 792 | 27
14219 | 914 | 27
14220 | 100 | 27
14221 | 1510 | 26,27
14223 | 2036 | 28
14224 | 3976 | 27
14225 | 12 | 26,27,28
14226 | 1903 | 26,27,28
14228 | 387 | 26
14260 | 5 | 26
TOTAL | 24474
Spreadsheet: 024f0463-c88e-4e6c-906d-6010e1e646e2
Sheet: General Info

General Information - Service Center Application
Instructions
Fill in the yellow highlighted areas
New Application
Renewal
 | (Indicate one of the above)
College/Division
Department
Service Center Name
Contact Information (Worksheet preparer)
Name
[NAME]
Phone #
College Fiscal Contact
Name
[NAME]
Phone #
Financially Responsible Person for the Service Center
Name
Title
[NAME]
Phone #
Percent of use by customer category
UI Departments including your own
External to UI
Are grants and contracts (K accounts) ever charged for this service?
No
Yes |  | If Yes, what percent?
Description of the product(s) or service(s) to be provided
Do competitors exist outside of the UI?
No
Yes
If yes, briefly describe how the service center rates compare to market rates
Does the service center provide services to certain users at discounted rates or free of charge?
Same fee charged to everyone
Different fees to differnent users
If different fees, please elaborate
Source of start-up (seed) money.  ([NAME] this field if reporting a new service center.  Include budget numbers and dollar amounts.
Budget
Amount
Identify the source of funds to be used to absorb the entire deficit if it exceeds 15% of the service center's total annual expense
Budget
Spreadsheet: 684217d1593194693-abc-on-unsorted-data-abc_unsorted
Sheet: sorted

Product | Category | Sales Value ($) | % Sales | % Cumm Sales | Grade
A-364 | A | 447
A-20 | A | 398
A-375 | A | 398
A-527 | A | 349
A-365 | A | 298
A-141 | A | 249
A-126 | A | 209
A-2 | A | 149
A-1 | A | 69
B-873 | B | 448
B-869 | B | 439
B-865 | B | 418
B-775 | B | 399
B-744 | B | 398
B-702 | B | 379
B-696 | B | 369
B-729 | B | 69
[NAME] | B | 69
Spreadsheet: 525557d1498769411-list-to-matrix-ef1107a_list_to_matrix
Sheet: Sheet1

Job Number | Employee | Occurances | Uniq_job | Job_Empls |  | Job Number | Employee 1 | 1-Count | Employee 2 | 2-Count | Employee 3 | 3-Count | Employee 4 | 4-Count | Employee 5 | 5-count
AA1 | [NAME] | 3 |  |  |  | 1 | [NAME] | 7 | [NAME] | 4 | [NAME] | 3
AA1 | [NAME] | 4 |  |  |  | 2 | [NAME] | 9 | [NAME] | 5 | [NAME] | 4 | [NAME] | 3
AA1 | [NAME] | 7 |  |  |  | 3 | [NAME] | 8 | [NAME] | 4 | [NAME] | 3 | [NAME] | 2 | [NAME] | 1
BB2 | [NAME] | 3 |  |  |  | 4 | [NAME] | 9 | [NAME] | 6 | [NAME] | 4 | [NAME] | 1
BB2 | [NAME] | 4 |  |  |  | 5 | [NAME] | 12 | [NAME] | 4 | [NAME] | 2
BB2 | [NAME] | 9
BB2 | [NAME] | 5
CC3 | [NAME] | 4 |  |  |  | Job_num | Employee 1 | 1-Count | Employee 2 | 2-Count | Employee 3 | 3-Count | Employee 4 | 4-Count | Employee 5 | 5-count | Employee 6 | 6-count
CC3 | [NAME] | 3
CC3 | [NAME] | 1
CC3 | [NAME] | 2
CC3 | [NAME] | 8
DD4 | [NAME] | 4
DD4 | [NAME] | 6
DD4 | [NAME] | 9
DD4 | [NAME] | 1
EE5 | [NAME] | 2
EE5 | [NAME] | 4
EE5 | [NAME] | 12
Spreadsheet: 776035d1649447024-maxifs-function-not-working-anymore-currently-returns-0-test-dashboard2
Sheet: QUOTATIONS

QID | DENOMINATION | PHONE | VAT | FIRST NAME | FAMILY NAME | ADDRESS | POST CODE | CITY | COUNTRY | [NAME] | LAST QUOTED IN
1 | Drinkland | 0484 14 68 85 | BE 0666 491 948 | [NAME] | Cakar | Rue de l'Orient, 2 | 1040 | Etterbeek | Belgique | [EMAIL] | 2022
Spreadsheet: 59334d1259826434-updating-old-data-and-adding-new-data-to-a-sheet-updateddata
Sheet: Sheet1

Key | Column 1 | Column 2 | Column 3
CY-001 | 100 | 200 | 300
CY-002 | 1000 | 2000 | 3000
CY-003 | 1 | 5 | 7
CY-004 | 5 | 10 | 15
CY-005 | 25 | 35 | 50
Spreadsheet: 1cc418a4-fc23-4af5-9927-d774f192f3b2
Sheet: Area 3

Location | Title | Name | Mobile | CRCs | CRC Mobile
Area 3 | Area Manager | [NAME] | 07764 960 387
Essex | RDO | [NAME] | 07889 601 261 | [NAME] | 07921 283179
 |  |  |  | [NAME] | 07595 799472
Essex | RDO | [NAME] | 07725 141 899 | [NAME] | 07738 029263
 |  |  |  | [NAME] | 07732 829972
 |  |  |  | [NAME] | 07894 489752
Sussex | RDO | [NAME] | 07793 167 075 | [NAME] | 07738 648 916
 |  |  |  | [NAME] | 07872 827 162
[NAME] | RDO | [NAME] | 07590 890 764 | [NAME] | 07711 470291
 |  |  |  | [NAME] | 07590 890810
 |  |  |  | La Toya Mason | 07711 385906
[NAME] | RDO | [NAME] | 07734 856 766 | [NAME] | 07809 316975
 |  |  |  | [NAME] | 07711 453867
Kent | RDO | [NAME] | 07764 336 704 | [NAME] | 07738 648829
 |  |  |  | Keith Forward | 07715 856695
 |  |  |  | [NAME] | 07715 856698
Kent | RDO | [NAME] | 07738 648 784 | [NAME] | 07809 512781
 |  |  |  | [NAME] | 07738 648950
Area 3 | URDO | [NAME] | 07872 672 478
Area 3 | WRDO | [NAME] | 07841 367 392
Spreadsheet: 32519d1228744398-vlookup-formula-food-fixed-2
Sheet: fixed formula

RECIPE CALCULATOR
ingredient | servings in recipe | serving size as per label | cal / serving | total calories | fat | total fat | sat fat | total sat fat | carbs | total carbs | sugar | total sugar | fiber | total fiber | protein | total protein |  | sodium | total sodium | calcium | total calcium | chol | total cholesterol
Land o Lakes fresh Buttery Taste Spread (14 grams) | 28 | 14 | 70 | 140 | 8 | 16 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80 | 160 | 0 | 0 | 0 | 0 |  | DIRECTIONS:
Maiers Italian Club Rolls  -  1 roll (53 grams / roll) | 2 | 1 | 150 | 300 | 1.5 | 3 | 0 | 0 | 27 | 54 | 1 | 2 | 1 | 2 | 5 | 10 |  | 340 | 680 | 100 | 200 | 0 | 0
Sugar, [NAME] (108 grams = 3.8oz = 1/2 cup) | 54 | 108 | 418 | 209 | 0 | 0 | 0 | 0 | 107.98 | 53.99 | 107.9 | 53.95 | 0 | 0 | 0 | 0 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Sugar, Granulated - 1 cup | 1 | 1 | 774 | 774 | 0 | 0 | 0 | 0 | 199.96 | 199.96 | 199.82 | 199.82 | 0 | 0 | 0 | 0 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
EGG - 1 RAW | 1 | 1 | 70 | 70 | 4.5 | 4.5 | 1.5 | 1.5 | 0.5 | 0.5 | 0 | 0 | 0 | 0 | 6 | 6 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
EGG - 1 RAW | 3 | 1 | 70 | 210 | 4.5 | 13.5 | 1.5 | 4.5 | 0.5 | 1.5 | 0 | 0 | 0 | 0 | 6 | 18 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
egg - 1 large whole raw (usda sr21) | 1 | 1 | 80 | 80 | 5.57 | 5.57 | 1.735 | 1.735 | 0.43 | 0.43 | 0.43 | 0.43 | 0 | 0 | 7.04 | 7.04 |  | 78 | 78 | 30 | 30 | 237 | 237
[NAME], cooked/roasted  (1 oz) | 2 | 1 | 46 | 92 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 18 |  | 21 | 42 | 0 | 0 | 24 | 48
[NAME] lean (raw)  grams | 150 | 100 | 176 | 264 | 10 | 15 | 4.058 | 6.087 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 30 |  | 0 | 0 | 0 | 0 | 0 | 0
Sugar, [NAME] (108 grams = 3.8oz = 1/2 cup) | 108 | 108 | 418 | 418 | 0 | 0 | 0 | 0 | 107.98 | 107.98 | 107.9 | 107.9 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Apple, raw without skin - 100 grams edible portion | 200 | 100 | 48 | 96 | 0.13 | 0.26 | 0.021 | 0.042 | 12.76 | 25.52 | 10.1 | 20.2 | 1.3 | 2.6 | 0.27 | 0.54 |  | 0 | 0 | 5 | 10 | 0 | 0
Apple, raw without skin - 100 grams edible portion | 50 | 100 | 48 | 24 | 0.13 | 0.065 | 0.021 | 0.0105 | 12.76 | 6.38 | 10.1 | 5.05 | 1.3 | 0.65 | 0.27 | 0.135 |  | 0 | 0 | 5 | 2.5 | 0 | 0
[NAME] all purpose enriched, unbleached (cup) | 2.5 | 1 | 455 | 1137.5 | 1.23 | 3.075 | 0.194 | 0.485 | 95.39 | 238.475 | 0.34 | 0.8500000000000001 | 3.4 | 8.5 | 12.91 | 32.275 |  | 0 | 0 | 0 | 0 | 0 | 0
total calories per recipe ===> | 3814.5
servings per recipe ===> | 6
calories per serving ===> | 635.75
fat per recipe === > | 62.97
fat per serving ===> | 10.495
sat fat per recipe ===> | 18.3595
sat fat per serving ===> | 3.059916666666667
carbs per recipe ===> | 688.735
carb per serving ===> | 114.7891666666667
sugar per recipe ===> | 390.2
sugar per serving ===> | 65.03333333333335
fiber per recipe ===> | 13.75
fiber per serving ===> | 2.291666666666667
protein per recipe ===> | 121.99
protein per serving ===> | 20.33166666666667
Spreadsheet: 271130d1381838326-multiple-if-condinations-with-and-between-functions-release-grouping
Sheet: Sheet1

 |  | [NAME] |  |  |  |  |  | Sample Data
 |  | Column1 | Column2 | Target Formula Result |  |  |  | Column1 | Column2 | [NAME]
 |  | > = 4 | > = 4 | Group1 |  |  |  | 4 | 5
 |  | > = 4 | Between 2 to 3 | Group1 |  |  |  | 4 | 3
 |  | > = 4 | < 2 | Group2 |  |  |  | 5 | 1
 |  | Between 2 to 3 | > = 4 | Group2 |  |  |  | 2 | 4
 |  | Between 2 to 3 | Between 2 to 3 | Group3 |  |  |  | 3 | 3
 |  | Between 2 to 3 | < 2 | Group3 |  |  |  | 2 | 1
 |  | < 2 | > = 4 | Group3 |  |  |  | 1 | 4
 |  | < 2 | Between 2 to 3 | Will be decided later |  |  |  | 1 | 3
 |  | < 2 | < 2 | Will be decided later |  |  |  | 1 | 1
Spreadsheet: 583761d1532629190-returning-names-in-ranked-order-with-ties-leaderboard
Sheet: Points

Place | Score
1 | 250
2 | 200
3 | 175
4 | 150
5 | 125
6 | 100
7 | 100
8 | 100
9 | 100
10 | 100
11 | 75
12 | 75
13 | 75
14 | 75
15 | 75
16 | 50
17 | 50
18 | 50
19 | 50
20 | 50
21 | 25
22 | 25
23 | 25
24 | 25
25 | 25
0 | 0
Spreadsheet: 41288d1239788689-grabbing-data-from-a-cell-on-another-worksheet-if-book1
Sheet: IHT411

NAME 1 | PRICE 1 | [NAME] 2 | PRICE 2 | NAME 3 | PRICE 3 | NAME 4 | PRICE 4 | NAME 5 | PRICE 5 | MY CURRENT WORKSHEET - WORKS BUT GRABS ALL SORT IDS |  |  | 1 | 2
UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 100.35 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 296.625 | FIRST STATE INVESTMENTS(UK) ASIA PACIFIC B ACC NAV | 356.02 | PEARSONS PLC | 245.26 | TRUMAN CO | 300 | This grabs call the results, but I only want results where Sort ID = 1 or 2
NAME 1 | PRICE 1 | [NAME] 2 | PRICE 2 | NAME 3 | PRICE 3 |  |  |  |  | RESULTS WHERE SORT ID = 1 or 2
UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | ???? | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | ???? | PEARSONS PLC | ???? |  |  |  |  | You showed me how to grab the name,which is working - I grab it from the worksheet "day1", however I need to grab the price (minimum value between cells H & I on worksheet "valuation results" where sort id = 1 or 2), the method needed to get this result needs to using the INDIRECT method as established in an earlier thread here: [NAME] in cell below
 |  |  |  |  |  |  |  |  |  | Example
 |  |  |  |  |  |  |  |  |  | 100.35
Spreadsheet: tracy_geaccone__40232__enron corp infomation request
Sheet: EGS Burn

 |  |  |  | YTD |  | Forecast Cash Expenditures
 |  | Headcount Actual (9/30) |  | Cash Expenditures |  | October |  | November |  | December |  | January |  | February |  | March | April | May | June | July | August | September | October | November | December |  | Comments
ETS
EGAS
PGE
EOTT
EREC
Azurix/Wessex
EEOS |  | 1272 |  |  |  | -80 |  | 55 |  | 55 |  | 10 |  | 10 |  | -20 | -10 | 0 | 10 | 0 | 10 | -10 | 0 | 10 | -10
Other
Analysts/Associates
Total
Depreciation & Amortization |  |  |  | 2.27 |  | 0.2 |  | 0.2 | 0.2 | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1
Taxes Other Than Income |  |  |  | 14.07 |  | 2 |  | 1 |  | 2 |  | 1 |  | 2 |  | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1
Total Expenses net of Capitalized Expense
Plus:  Capital Expenditures |  |  |  | 5.28 |  | 1 |  | 0 |  | 1 |  | 0 |  | 0 |  | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1
Other Cash Payments |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less: DD&A
 |  |  |  |  |  | 0
Total Cash Burn Rate
Spreadsheet: 697845d1601567792-calculating-overtime-past-40-hours-work-hours-and-cost-estimate
Sheet: Work Hours and Cost Estimate

People per Shift | 8
Total Man hours | 1500
Regular Rate | 75
OT Rate | 140
 |  |  |  |  |  |  |  | Revise formula
Scenario | Hours | RP |  | OT Hours |  | Calc | Number of Hours | Number of Days | Regular Rate Cost | OT Rate Cost
8x5 | 8 | 5
8x5+Sat | 8 | 6
8x5+Sat/Sun | 8 | 7 |  | 2
10x5 | 10 | 5 |  | 10
10x5+Sat | 10 | 6 |  | 20
10x5+Sat/Sun | 10 | 7 |  | 30
12x5 | 12 | 5 |  | 20
12x5+Sat | 12 | 6 |  | 32
12x5+Sat/Sun | 12 | 7 |  | 44
16x5 CON | 16 | 5
16x6 Sat CON | 16 | 6
16x7 Sun CON | 16 | 7
20x5 CON | 20 | 5
20x6 CON | 20 | 6
24x5 CON | 24 | 5
24x6 CON | 24 | 6
 | Need to add overtime hours after regular dayshift
 | 5/6/7 day option 16 hours for sat/sun
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Ault

Hour
Ending
Pacific | Midway physical | From 4C 230 | WAPA Option | WAUC | Mean | Tristate | To CSU | To San Juan | Tristate | Tristate | Pac(t) | Balance
Standard | position | WAPA Trans |  | Purch | Purch | Purch | Call Option | WAPA trans | Sale | Sale | to 4C
(PST)
 |  |  | PV Index+5
100 | 0
200 | 0
300 | 0
400 | 0
500 | 0
600 | 0
700 | 0
800 | 0
900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
Spreadsheet: 867838d1714634623-copy-the-format-from-the-adjacent-cell-problem1
Sheet: Sheet1

 |  |  |  |  |  |  | Test area
 |  | [NAME] |  |  | [NAME]
 |  | UUU746560102316 |  |  | UUU746560102316
 |  | UUU746560202625 |  |  | UUU746560202625
 |  | UUU746560402641 |  |  | UUU746560402641
 |  | TTT8484301776
 |  | TTT8484405501
 |  | [NAME]
Problem - |  | TTT838482625
Spreadsheet: 162152d1339748709-looking-up-data-and-providing-the-difference-plus-a-word-below-and-above-example
Sheet: Sheet1

 | target | achieved | difference |  | Range
Example | 4a | 5c |  |  | 2A
Example | 4a | 4a |  |  | 3C
Example | 5b | 4c |  |  | 3B
 |  |  |  |  | 3A
 |  |  |  |  | 4C
 |  |  |  |  | 4B
 |  |  |  |  | 4A
 |  |  |  |  | 5C
 |  |  |  |  | 5B
 |  |  |  |  | 5A
 |  |  |  |  | 6C
 |  |  |  |  | 6B
 |  |  |  |  | 6A
 |  |  |  |  | 7C
 |  |  |  |  | 7B
 |  |  |  |  | 7A
 |  |  |  |  | 8C
 |  |  |  |  | 8B
 |  |  |  |  | 8A
Spreadsheet: 820869d1678314613-formula-that-looks-for-a-color-name-example-workbook-eba
Sheet: Sheet1

Object 1 |  |  |  | 13900
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Object 9 |  |  |  | 95800
Object 10 |  |  |  | 41000
 |  |  |  |  |  |  |  |  |  | Group 1 | 0
 |  |  |  |  |  |  |  |  |  | Group 2 | 0.05
 |  |  |  |  |  |  |  |  |  | Group 3 | 0.25
 |  |  |  | Price | Price with add |  |  |  |  | Group 4 | 0.1
Group 1
Object 1 |  |  |  | 13900
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Group 2
Object 10 |  |  |  | 41000
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 1 |  |  |  | 13900
Object 1 |  |  |  | 13900
Object 9 |  |  |  | 95800
Object 6 |  |  |  | 68600
Group 3
Object 3 |  |  |  | 80200
Object 3 |  |  |  | 80200
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Group 4
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Object 9 |  |  |  | 95800
Object 10 |  |  |  | 41000
Spreadsheet: 727090d1617712211-formula-doesnt-work-only-for-one-particular-entry-confused-accounting-module-belinda-original-copy
Sheet: Monthly Expenses Summary

 | MONTHLY EXPENSES SUMMARY - KEGALLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2021
 | G/L Code | Final Acc. Entry | Account Title | January | February | March | April | May | June | July | August | September | October | November | December | Total | Trend
 |  |  | Expenses
 |  |  | Building Rent
 |  |  | Electricity
 |  |  | Fuel
 |  |  | Internet Charges
 |  |  | Mobile Charges
 |  |  | Statationery
 |  |  | Computers
 |  |  | Furniture
 |  |  | Travelling Costs
 |  |  | Marketing/Advertising
 |  |  | Charitables
 |  |  | Sponsorships
 |  |  | Entertainment
 |  |  | Insurance
 |  |  | Water Bill
 |  |  | Car
 |  |  | Motor Bike
 |  |  | Mobile Phones
 |  |  | Owners Withdrawals
 |  |  | Salaries
 |  |  | Loans Disburesed
 |  |  | Interest Paid
 |  |  | Petty Cash
 |  |  | EPF
 |  |  | ETF
 |  |  | Bonus
 |  |  | Incomes
 |  |  | Document Charges
 |  |  | Loan Capital Recovery
 |  |  | Loan Interest Recovery
 |  |  | Donations
 |  |  | Other Incomes
 |  |  | Owners Capital
 |  |  | Third Party Loans
 | Total
 | Profit & Loss |  | Incomes
 |  |  | Expenses
 |  |  | Profit/Loss
 | Assets |  | Car
 |  |  | Motor Bike
 |  |  | Mobile Phones
 |  |  | Furniture
 |  |  | Debtors
 |  |  | Cash Balance
 |  |  | Total Assets
 | Liabilities |  | Equity Capital
 |  |  | Debt Capital
 |  |  | Working Capital
 |  |  | Total Liabilities