tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167795d1342105316-if-cell-contains-value-between-x-y-should-equal-certain-text-numberequaltext
Sheet: Sheet1

 |  |  |  |  | 0 | Off track | 51 | Warning
 |  |  |  |  | 1 | Off track | 52 | Warning
 |  |  |  |  | 2 | Off track | 53 | Warning
 |  |  |  |  | 3 | Off track | 54 | Warning
 |  |  |  |  | 4 | Off track | 55 | Warning
 |  |  |  |  | 5 | Off track | 56 | Robust
 |  |  |  |  | 6 | Off track | 57 | Robust
 |  |  |  |  | 7 | Off track | 58 | Robust
 |  |  |  |  | 8 | Off track | 59 | Robust
 |  |  |  |  | 9 | Off track | 60 | Robust
 |  |  |  |  | 10 | Off track | 61 | Robust
 |  |  |  |  | 11 | Off track | 62 | Robust
 |  |  |  |  | 12 | Off track | 63 | Robust
 |  |  |  |  | 13 | Off track | 64 | Robust
 |  |  |  |  | 14 | Off track | 65 | Robust
 |  |  |  |  | 15 | Off track | 66 | Strong
 |  |  |  |  | 16 | Off track | 67 | Strong
 |  |  |  |  | 17 | Off track | 68 | Strong
 |  |  |  |  | 18 | Off track | 69 | Strong
 |  |  |  |  | 19 | Off track | 70 | Strong
 |  |  |  |  | 20 | Off track | 71 | Strong
 |  |  |  |  | 21 | Off track | 72 | Strong
 |  |  |  |  | 22 | Off track | 73 | Strong
 | 42 |  |  |  | 23 | Off track | 74 | Strong
 |  |  |  |  | 24 | Off track | 75 | Strong
 |  |  |  |  | 25 | Off track | 76 | Strong
 |  |  |  |  | 26 | Off track | 77 | Strong
 |  |  | 0 | Off track | 27 | Off track | 78 | Strong
 |  |  | 51 | Warning | 28 | Off track | 79 | Strong
 |  |  | 56 | Robust | 29 | Off track | 80 | Strong
 |  |  | 66 | Strong | 30 | Off track | 81 | Commitment
 |  |  | 81 | Commitment | 31 | Off track | 82 | Commitment
 |  |  | 90 | Streched | 32 | Off track | 83 | Commitment
 |  |  |  |  | 33 | Off track | 84 | Commitment
 |  |  |  |  | 34 | Off track | 85 | Commitment
 |  |  |  |  | 35 | Off track | 86 | Commitment
 |  |  |  |  | 36 | Off track | 87 | Commitment
 |  |  |  |  | 37 | Off track | 88 | Commitment
 |  |  |  |  | 38 | Off track | 89 | Commitment
 |  |  |  |  | 39 | Off track | 90 | Streched
 |  |  |  |  | 40 | Off track | 91 | Streched
 |  |  |  |  | 41 | Off track | 92 | Streched
 |  |  |  |  | 42 | Off track | 93 | Streched
 |  |  |  |  | 43 | Off track | 94 | Streched
 |  |  |  |  | 44 | Off track | 95 | Streched
 |  |  |  |  | 45 | Off track | 96 | Streched
 |  |  |  |  | 46 | Off track | 97 | Streched
 |  |  |  |  | 47 | Off track | 98 | Streched
 |  |  |  |  | 48 | Off track | 99 | Streched
 |  |  |  |  | 49 | Off track | 100 | Streched
 |  |  |  |  | 50 | Off track
Spreadsheet: 865625d1712668156-power-query-help-file-3
Sheet: Sheet1

 |  |  | 2024-03-31 00:00:00 | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00
167638 | Dion | Cortes |  |  | Sick |  |  | DO | DO |  |  |  |  |  |  |  |  |  |  | DO |  | DO
3314 | [NAME] | Harvey |  |  |  |  |  | DO | DO | VAC | VAC | VAC | VAC | VAC | DO | DO
169003 | Cayden | Leonard |  |  |  | EV |  | DO | DO |  |  |  |  |  |  |  |  |  |  | DO |  | DO
156127 | Demi | Chung |  |  |  | Sick |  | DO | DO |  |  |  |  |  |  |  |  |  |  | DO |  | DO
127099 | [NAME] | Montes |  |  |  | PLP-3 |  | DO | DO |  |  |  |  |  | DO | DO
4054 | [NAME] | Bentley |  |  |  | S | S | DO | DO | S | S | S | S | S | DO | DO
121614 | Jaylin | Solis |  |  |  |  |  | DO | DO |  |  |  |  |  | DO | DO
126906 | Ronin | Mendoza | PLU-3 |  |  |  |  | DO | DO |  |  |  |  |  | DO | DO
159416 | [NAME] | Stuart |  |  |  |  |  | DO | DO |  |  |  |  |  | DO | DO
143017 | Paola | Pugh | DO |  |  |  |  |  | DO
148247 | Judson | [NAME] | DO |  |  |  |  |  | DO
149610 | Genevieve | West | DO | Sick |  |  |  | PLP-3 | DO
146727 | Diego | [NAME] | DO |  |  |  |  |  | DO
127091 | [NAME] | McClain |  |  |  |  |  | DO | DO
145809 | Marleigh | Hendrix |  |  |  |  |  | DO | DO
162712 | Korbyn | Coffey |  |  | Sick | Sick |  | DO | DO
125105 | Elora | Atkins |  |  |  |  |  | DO | DO
126812 | Cason | [NAME] | RET | RET | RET | RET | RET | DO | DO
126254 | Sierra | Warner |  |  |  |  |  | DO | DO
143020 | Silas | [NAME] |  |  |  | Sick |  | DO | DO
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Batterbee

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 718632d1613242353-revenue-based-tiered-commission-formula-revenue-based-tiered-commission-
Sheet: Revenue Report Feb 12th

Day/ Date | Friday, February 12th 2021
[NAME] | Item | [NAME] | [NAME] | Amount | Sharing | Description
1 | Net Sales |  |  | 5540 |  | Net Sales Achieved
2 | [NAME] | 0 | 2700 | 2700 |  | Threshold at $2,700
 | 0% of Tier 1 |  |  |  |  | 0% of $0 - $2,700
3 | [NAME] | 2701 | 5999
 | 15% of Tier 2 |  |  |  |  | 15% of [NAME] 3
4 | Tier 3 | 5999 | 7999
 | 20%  of Tier 3 |  |  |  |  | 20% of [NAME]
7 | Amount to be Paid |  |  |  |  | [NAME], 5 and 6
We are paying out commission based on revenue reached, table as per below. Having difficulties doing the calculation. Logically I understand that I have to manually substract whatever is after $2700 but only UNTIL $5,999 but I want to have a formula that does it for me and changes based on my Net Sales, and the same for Tier 3.
 | Table
 | Amount | Percentage
 | $0- $2,700 | 0
 | $2,701-$5,999 | 0.15
 | $6,000-$7,999
 | Table
 | Amount | Percentage | Difference
 | 0 | 0
 | 2700 | 0.15
 | 6000 | 0.2
 | 999999 | 0
 | Net Sales | Bonus
 | 7000
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (20)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
20.01
20.02
20.03
20.04 |  |  |  |  |  |  |  |  |  | 0
20.05 |  |  |  |  |  |  |  |  |  | 0
20.06 |  |  |  |  |  |  |  |  |  | 0
20.07 |  |  |  |  |  |  |  |  |  | 0
20.08 |  |  |  |  |  |  |  |  |  | 0
20.09 |  |  |  |  |  |  |  |  |  | 0
20.1 |  |  |  |  |  |  |  |  |  | 0
20.11 |  |  |  |  |  |  |  |  |  | 0
20.12 |  |  |  |  |  |  |  |  |  | 0
20.13 |  |  |  |  |  |  |  |  |  | 0
20.14 |  |  |  |  |  |  |  |  |  | 0
20.15 |  |  |  |  |  |  |  |  |  | 0
20.16 |  |  |  |  |  |  |  |  |  | 0
20.17 |  |  |  |  |  |  |  |  |  | 0
20.18 |  |  |  |  |  |  |  |  |  | 0
20.19 |  |  |  |  |  |  |  |  |  | 0
20.2 |  |  |  |  |  |  |  |  |  | 0
20.21 |  |  |  |  |  |  |  |  |  | 0
20.22 |  |  |  |  |  |  |  |  |  | 0
20.23 |  |  |  |  |  |  |  |  |  | 0
20.24 |  |  |  |  |  |  |  |  |  | 0
20.25 |  |  |  |  |  |  |  |  |  | 0
20.26 |  |  |  |  |  |  |  |  |  | 0
20.2699999999999 |  |  |  |  |  |  |  |  |  | 0
20.2799999999999 |  |  |  |  |  |  |  |  |  | 0
20.2899999999999 |  |  |  |  |  |  |  |  |  | 0
20.2999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 0ebc9a22-9bf1-4518-b3ba-06dc2eddf2f8
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 4/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.50195271570364 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.18290210294554 | -1.710578956392525 | 53.47232314655302
 | [NAME] | 39.68639703314219 | 0.4116515212131603 | 0.1556294004142207 | 0.2911846112394774 | 40.54486256600905 | -0.07359084686626552 | 40.47127171914278
 | [NAME] | 18.15775402767459 | 0.3276752205139929 | 0.1724812688977974 | 0.2628505022629731 | 18.92076101934935 | -1.653072499503316 | 17.26768851984604
 | [NAME] | 11.45222355578417 | 0.1001822534656735 | 0.5687614475406668 | 0.6743722960217218 | 12.79553955281223 | 5.569390126742816 | 18.36492967955505
 | MY Sep-Aug | 121.7983273323046 | 3.1178170226007 | 0.9302710396612208 | 1.597649846549658 | 127.4440652411162 | 2.132147823980709 | 129.5762130650969 | 92.37017534250782 | 1.402792758426942
2011/12 | Q1 Sep-Nov | 46.36464663783633 | 1.125526280695738 | -0.04624466235028046 | 0.33730317487533 | 47.78123143105712 | -0.4361019712222776 | 47.34512945983484
 | [NAME] | 39.12698684853912 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594563 | 39.77088770773403 | 1.192639826691378 | 40.96352753442541
 | [NAME] | 21.78890349456733 | 0.3898827100518819 | 0.02449399488891973 | 0.2052333688042667 | 22.40851356831239 | -1.866224686136671 | 20.54228888217572
 | [NAME] | 8.177732055653985 | 0.1344738463101611 | 0.9865092519261807 | 0.7466332096840184 | 10.04534836357435 | 11.66425809050259 | 21.70960645407694
 | MY Sep-Aug | 115.4582690365968 | 1.794567957681634 | 1.23562950927642 | 1.517514567123071 | 120.0059810706779 | 10.55457125983502 | 130.5605523305129 | 92.61411956668705 | 1.409726216060418
2012/13 | Q1 Sep-Nov | 52.40903519968503 | 1.999784089970979 | 0.0731989429480428 | 0.3741566581481997 | 54.85617489075225 | -0.8283324760435123 | 54.02784241470874
 | [NAME] | 27.24627078927816 | 0.2440545363332127 | 0.2257366568962843 | 0.3444291130180139 | 28.06049109552567 | 0.2061033592153213 | 28.26659445474099
 | MY Sep-Aug | 111.7651914931449 | 2.413112089056537 | 1.319118107321799 | 1.771086355018099 | 117.2685080445413 | 7.659000046266436 | 124.9275080908077 | 92.06841071555041 | 1.356898713900656
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 4/11/2013
Spreadsheet: 195059d1353411274-number-of-occurence-00__fotis_sample-14-
Sheet: Tabelle1

12 | 0 | 0 | 0 | 0 | 0 | 1
13 | -1 | 0 | 0 | 0 | 0 | 0
14 | 1 | 0 | 0 | 0 | 0 | 0
21 | 0 | 0 | 0 | -1 | 0 | 0
23 | 1 | 0 | 0 | 0 | 0 | 0
24 | 0 | 0 | 0 | 0 | 0 | 0
31 | 0 | 1 | 1 | 0 | 0 | 0
32 | 0 | 0 | 0 | 1 | 0 | 0
34 | 0 | 0 | 0 | 0 | 0 | 0
41 | 0 | 0 | 0 | 0 | 0 | -1
42 | 0 | 0 | 1 | 1 | 0 | 0
43 | 0 | 0 | 0 | 0 | 1 | 0
 | 13 | 31 | 31 | 21 | 43 | 12
 | 14 |  | 42 | 32 |  | 41
 | 23 |  |  | 42
Spreadsheet: 847489d1698397499-calculate-accumulated-values-for-each-day-during-the-last-90-days-from-newest-date-volymeday
Sheet: Blad1

 | Date: | Total per day | date 2 |  |  | Presentation to be:
 |  |  |  |  | Find automatically accumulated value with newest date on the top |  |  |  |  |  |  | Find values for each month where values exist
 | 2023-12-10 00:00:00 | 3000 |  |  | If a "date2" exist in D column, the row should not be calculated.
 | 2023-12-10 00:00:00 | 4000 |  |  | Values to calculated 90 days backwards from newest date
 | 2023-12-01 00:00:00 | 2000 |  |  |  | 2023-12-10 00:00:00 | 7000 |  |  |  |  | 2023-DEC | 15000
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-12-01 00:00:00 | 8000 |  |  |  |  | 2023-NOV | 36000
 | 2023-10-29 00:00:00 | 7000 |  |  |  | 2023-11-09 00:00:00 | 21000 |  |  |  |  | 2023-OCT | 16000
 | 2023-12-01 00:00:00 | 6000 |  |  |  | 2023-11-01 00:00:00 | 15000
 | 2023-11-01 00:00:00 | 3000 |  |  |  | 2023-10-29 00:00:00 | 9000
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-10-28 00:00:00 | 7000
 | 2023-11-09 00:00:00 | 2000 | 2023-11-09 00:00:00
 | 2023-10-28 00:00:00 | 7000
 | 2023-11-01 00:00:00 | 1000
 | 2023-11-01 00:00:00 | 8000
 | 2023-11-01 00:00:00 | 2000
 | 2023-11-09 00:00:00 | 10000
 | 2023-11-09 00:00:00 | 9000
 | 2023-11-09 00:00:00 | 2000
 | 2023-11-01 00:00:00 | 1000
Matris is about 2000 rows
Spreadsheet: 106392d1303605791-multiple-drop-list-dependentlists
Sheet: Choices

On this page we use Validation List of |  |  |  |  |  | Sample Lists
Allow: =Animals
for both H5 and H19 versions. |  |  |  |  |  | Problematic
 |  |  |  |  |  |  | Classes | Types | Animals
Then, the validation list for I5 uses an INDIRECT formula |  |  |  |  |  |  | Avian | Tigers | [NAME]
Allow:  =INDIRECT(H5)
so the word chosen becomes the active "list" and the animal
names are brought over. The same thing is used in the |  |  |  |  |  |  | NOTE: Problem if you make selections in the boxes above, and then go back and change an earlier box
validation list for J5: |  |  |  |  |  |  | it does not change the others, so you could end up with Canine - Tiger - Bald Eagle.
Allow:  =INDIRECT(I5)
This technique could go on indefinitely. |  |  |  |  |  |  | SOLUTION: A WorkSheet_change macro can be used to watch for changes in the earliest boxes and then
 |  |  |  |  |  |  | clear the previous made in later boxes that are now no longer valid.
The "LISTS" are on the next sheet.
 |  |  |  |  |  |  | Right-click on the sheetname tab and VIEW CODE to see the macro.
 |  |  |  |  |  | Better
 |  |  |  |  |  |  | Classes | Types | Animals
 |  |  |  |  |  |  | Feline
Spreadsheet: danny_mccarty__4660__IdleAire 10-2001 Valuation
Sheet: 3-2001 Value

IDLEAIRE 3-2001 VALUATION SUMMARY
 |  | PRE-MONEY |  |  | POST-MONEY
Valuation Technique
 | Discounted Cash Flow Valuation
 | Comparable Public Company Analysis
 | Comparable Transaction Analysis
 | Average Valuation
 | Discount | 0.25
 | New Equity |  |  |  | 10000000
 | Discounted Average Valuation
Common Shares
 | Founders | 36000000
 | Seed Investors | 3410000
 | Key Employees | 1110000
 | 1st Round Investors | 4527600
 | 2nd Round Investors
 | Public Round
 | Total Common Shares Outstanding
 | Total Prefered Shares Outstanding | 0
 | Options & Warrants
 | Fully Diluted Shares
 | Price Per Fully Diluted Share
Spreadsheet: 691375d1597670209-listing-multiple-occurances-nom_list
Sheet: Sheet1

 |  |  | 4000 | a |  |  |  |  | a | 4000 | 4003 | 4004 | 4006
 |  |  | 4001 | b |  |  |  |  | b | 4001 | 4002 | 4005
 |  |  | 4002 | b |  |  |  |  | c | 4007
 |  |  | 4003 | a |  |  |  |  | d | 4008
 |  |  | 4004 | a |  |  |  |  | e | 4009 | 4010
 |  |  | 4005 | b |  |  |  |  | f | 4011
 |  |  | 4006 | a |  |  |  |  | g | 4012 | 4013
 |  |  | 4007 | c |  |  |  |  | h | 4014
 |  |  | 4008 | d |  |  |  |  | i | 4015
 |  |  | 4009 | e |  |  |  |  | j | 4016
 |  |  | 4010 | e
 |  |  | 4011 | f
 |  |  | 4012 | g
 |  |  | 4013 | g
 |  |  | 4014 | h
 |  |  | 4015 | i
 |  |  | 4016 | j
Spreadsheet: 75381d1275959688-how-to-make-hide-0-with-blanks-but-still-keeping-its-value-in-the-cell-testing
Sheet: Total Received

Date | Ver | [NAME] | Total Received |  |  |  |  |  |  |  | Remarks
 |  |  | A | B | C | D | E | F | G | H
 |  | Item 1 |  |  |  |  |  |  | 20 | 20
 |  | Item 2 |  |  | 21 | 50 | 19 | 16 | 50 | 50
 |  | Item 3 |  |  |  |  |  |  |  | 21
 |  | Item 4 |  |  |  |  |  |  | 17
 |  | Item 5 |  | 41
 |  | Item 6 | 39
Spreadsheet: 112657d1308707488-code-required-for-merging-data-from-one-worksheet-to-another-data-merge-and-addition
Sheet: Sheet1

Our Reference: |  |  |  |  |  | 2132
Date: |  | 2011-02-01 00:00:00
[NAME]
manager
111 street name
suburb
Dear |  | name
Subject: |  |  | Name
Further to your request for a quotation regarding the above,we are pleased to submit the following for your consideration. All work done during normal hours.
Supply and Install
 |  | I want the data to be added here.
 |  | but it needs to add a line each time so that the data below isnt affected
Expenditure Summary
Price |  |  | 0
Further to your request for a quotation regarding the above,we are pleased to submit the following for your consideration. All work done during normal hours.
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, January 4 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 865618d1712663883-how-to-automatically-match-cell-info-from-one-sheet-to-another-if-it-matches-a-cell-in-she-complete-list-mt-aligw
Sheet: Sheet1

Client Names
Summer Winds | manually input client name into A3 |  | When client name manually input into sheet1 A3 it needs to match that name in all clients incl contacts from D4:D203
Vehicle Details | Make & Model | Vehicle Reg | MOT | Service
OCC Approved  Drivers
Drivers Name | Driving Licence | [NAME] | Endorsements | [NAME]
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -214291 | -221478
2 | -220732 | -218763
3 | -204218 | -201577
4 | -197616 | -196577
5 | -173324 | -171577
6 | -187830 | -186155
7 | -187233 | -186597
8 | -178115 | -176830
9 | -164985 | -164562
10 | -192162 | -191649
11 | -189681 | -189093
12 | -231525 | -230901
13 | -184812 | -192355
14 | -99614 | -106819
15 | -100945 | -100358
16 | -105000 | -108344
17 | -72267 | -68561
18 | -107202 | -106818
19 | -132373 | -131263
20 | -144973 | -144578
21 | -169707 | -169914
22 | -227739 | -225846
23 | -171285 | -170801
24 | -182710 | -182471
25 | -172381 | -173436
26 | -150284 | -148415
27 | -218118 | -216713
28 | -223602 | -222764
29 | -221781 | -221856
30 | -224912 | -224764
31
2001-10-31 00:00:00 |  |  | 74620
2001-11-30 00:00:00
CBS Dollars
 |  |  | -45645.68
Spreadsheet: 854258d1704205233-create-spread-for-actual-values-against-planned-plan-vs-actual-distribution-excelforum-windknife-4-1-
Sheet: Sheet1

Activity | Company | Month | Plan | Actual
Activity 1 | ABC | 2023-01-01 00:00:00 | 100 | 200 |  |  |  | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC | 2023-01-01 00:00:00 | 100 | 60 |  |  | 2023-01-01 00:00:00 | 400 | 310 | 190 | 0
Activity 1 | DEF | 2023-01-01 00:00:00 | 200 | 50 |  |  | 2023-02-01 00:00:00 | 300 | 0 | 200 | 50
Activity 1 | ABC | 2023-02-01 00:00:00 | 200 | 150 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 250
Activity 1 | ABC | 2023-03-01 00:00:00 | 50 | 300
Activity 1 | DEF | 2023-02-01 00:00:00 | 50 | 150
Activity 2 | ABC | 2023-02-01 00:00:00 | 50 | 90
Plan/Actual |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  | Plan | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
2023-01-01 00:00:00 | 400 | 310 | 190 |  |  |  | 2023-01-01 00:00:00 | 400 | 310 | 190
2023-02-01 00:00:00 | 300 |  | 200 | 50 |  |  | 2023-02-01 00:00:00 | 300 |  | 200 | 50
2023-03-01 00:00:00 | 50 |  |  | 250 |  |  | 2023-03-01 00:00:00 | 50 |  |  | 250
[NAME] for January
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC | 200
Activity 2 | ABC | 60 | 40
Activity 1 | DEF | 50 | 150
[NAME] for February
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  | 150 | 50
Activity 2 | ABC |  | 50
Activity 1 | DEF
[NAME] for March
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  |  | 250
Spreadsheet: john_griffith__15644__05_08_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 40 | 42 | 0.56
N01-P/C | 435 | 67 | 70 | 0.54
Q01-P/C | 440 | 87 | 89 | 0.55
U01-P/C | 445 | 104.5 | 106.5 | 0.55
V01-P/C | 450 | 119 | 122 | 0.555
X01-P/C | 465 | 137.5 | 139 | 0.565
[NAME]-P/C | 485 | 156 | 160 | 0.565
F02-P/C | 490 | 170 | 174 | 0.575
G02-P/C | 480 | 174 | 180 | 0.565
H02-P/C | 460 | 160.5 | 163 | 0.51
J02-P/C | 430 | 124 | 124.5 | 0.405
K02-P/C | 425 | 109 | 119 | 0.36
M02-P/C | 430 | 118 | 120 | 0.355
U02-P/C | 435 | 132 | 142
Spreadsheet: 206401d1358179126-darts-scoreboard-darts1
Sheet: Running Total

 | Player 1 | Player 2 | Player 1 | Player 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
 |  |  | 0 | 0
 |  |  | #N/A | #N/A
 | 0 | 0
Spreadsheet: 83883d1283924766-ranking-based-on-3-conditions-tiebreakertest4
Sheet: Sheet1

 |  |  |  | 1st tie breaker |  |  |  |  |  | Nescessary helper columns |  |  | Can be deleted - different sub-functions of Ties 3 - just to better understand what I have done
Team | RANK | Ties | Final Rank with ties shown correctly | Add hi/low ranks for tie breaker | see only ties |  | Correct answer doing it by hand | [NAME] after tie-breaker | Correct answer? | Ties 2 | Ties 3 |  | Identify min of 3 | identify [NAME] of 3
A | 1 |  |  | 14.5 |  |  | 2 | 2
B | 1 |  |  | 8 |  |  | 1 | 1
C | 5 |  |  | 28.5 |  |  |  | 5
D | 8 |  |  | 39 |  |  | 9 | 9
E | 8 |  |  | 37.5 |  |  | 8 | 8
F | 6 |  |  | 31 |  |  |  | 6
G | 7 |  |  | 35 |  |  |  | 7
H | 11 |  |  | 55 |  |  | 12 | 12
I | 4 |  |  | 24.5 |  |  |  | 4
J | 11 |  |  | 45 |  |  | 11 | 11
K | 10 |  |  | 38.5 |  |  |  | 10
L | 1 |  |  | 18.5 |  |  | 3 | 3
 |  |  |  |  |  | If Col C=2, then look at D and find the duplicate. Then look at E to find out which number is the lowest.  The lower number, subtract 0.5 from ColumnD.  If they are equal, add 0 (and we'll go on to tie-breaker #2).  If it is the higher number, add 0.5.
 |  |  |  |  |  | If Col C=3, then look at D to find the other 2 duplicates.  Then look at E to find out which number is the lowest.  The lower number, subtract 1 from ColumnD.  The middle number stays the same, add 0.  If it is the higher number, add 1.
Spreadsheet: 141929d1329515849-cell-addressing-example1
Sheet: Sheet1

 |  |  |  | [NAME] |  | Distinguishing cell: Currently using the ISBLANK function, but this is not distinguishing cells in column E that have a formula, but are not showing a value. What function would help on this…? |  | Source values
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 2