tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266067d1379493656-help-to-create-forumla-that-automatically-fills-a-row-of-info-when-conditions-match-auto-invoicing
Sheet: Sheet 2

Invoice Number |  |  | 455 |  |  |  |  | Invoice Number |  |  | 722
FLOOR | PLOT | House Type | [NAME] | AMOUNT |  | PAID |  | FLOOR | PLOT | House Type | [NAME] | AMOUNT |  | PAID
GF | 1 | A | Stage 1 | 200 |  | 200 |  | SF | 3 | C | Stage 1 | 400
 |  |  |  |  |  |  |  | SF | 3 | C | Stage 2 | 160
Basically, I want these invoices to automatically generate when I type in the INVOICED amounts and INVOICE REF on Sheet 1
So if the 'Invoice Number' above matches the 'Invoice Ref' on sheet 1, I want this page to list the information that pertains to that invoice reference.
Spreadsheet: 858424d1707131541-how-to-insert-high-medium-or-low-based-on-the-value-of-two-cells-excel-high-low-etaf
Sheet: Sheet2

Column2 |  | One | Two | Three
High |  | High | High
Medium |  | Medium | High | High
Low |  | Low | High | Medium
 |  | High | Medium | High
 |  | Medium | Medium | Medium
 |  | Low | Medium | Low
 |  | High | Low | Medium
 |  | Medium | Low | Low
 |  | Low | Low | Low
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 025MM

025MM
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-08-31 00:00:00 |  |  | CJY | 2010-06-03 00:00:00 |  |  | JAD |  | 2010-10-28 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 879360d1726839412-sum-a-range-of-cells-sum-to-forum
Sheet: Sheet1

 |  |  |  |  |  |  | # of occcurances | Day |  |  | total of Occurances
 |  |  |  |  |  |  | 10 | 1 | 1 to 5
 |  |  |  |  |  |  | 2 | 2 | 5.25 to 10 |  | 18
 |  |  |  |  |  |  | 5 | 3 | 10.25 to 20 |  | 56 | Continue formula in L4 down through data set
 |  |  |  |  |  |  | 6 | 4 | 20.25 to 30 |  | 29
 |  |  |  |  |  |  | 12 | 5
 |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  | 1 | 7
 |  |  |  |  |  |  | 8 | 8
 |  |  |  |  |  |  | 4 | 9
 |  |  |  |  |  |  | 3 | 10
 |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  | 9 | 12
 |  |  |  |  |  |  | 8 | 13
 |  |  |  |  |  |  | 4 | 14
 |  |  |  |  |  |  | 2 | 15
 |  |  |  |  |  |  | 6 | 16
 |  |  |  |  |  |  | 6 | 17
 |  |  |  |  |  |  | 8 | 18
 |  |  |  |  |  |  | 5 | 19
 |  |  |  |  |  |  | 6 | 20
 |  |  |  |  |  |  | 4 | 21
 |  |  |  |  |  |  | 4 | 22
 |  |  |  |  |  |  | 3 | 23
 |  |  |  |  |  |  | 2 | 24
 |  |  |  |  |  |  | 2 | 25
 |  |  |  |  |  |  | 1 | 26
 |  |  |  |  |  |  | 1 | 27
 |  |  |  |  |  |  | 5 | 28
 |  |  |  |  |  |  | 3 | 29
 |  |  |  |  |  |  | 4 | 30
 |  |  |  |  |  |  | 1 | 31
Spreadsheet: aa17bdeb-eebc-4bb2-9928-0888306dcd37
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Vermögende Ausländerinnen und Ausländer werden in Zukunft im [NAME] Einkommen und Vermögen besteuert. [NAME] ist nicht mehr möglich.
 | Wenn am <b>nächsten Sonntag</b> schon [NAME] wären, welcher Partei würden [NAME] hauptsächlich geben?
Antwort | CVP | EDU | EVP | FDP / Liberale | Grüne | SD | SP | SVP | Andere | Weiss nicht/Keine | Grünliberale | BDP | PdA
[NAME] | 0.69 | 0.7 | 0.83 | 0.53 | 0.82 | 0.79 | 0.88 | 0.61 | 0.76 | 0.73 | 0.77 | 0.7 | 0.95
[NAME] | 0.23 | 0.18 | 0.09 | 0.38 | 0.11 | 0.18 | 0.06 | 0.31 | 0.16 | 0.15 | 0.16 | 0.24 | 0.03
Neutral / Weiss nicht | 0.08 | 0.13 | 0.08 | 0.09 | 0.07 | 0.03 | 0.05 | 0.08 | 0.08 | 0.12 | 0.07 | 0.06 | 0.02
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 17

Product* | January 3 | January 10 | January 17 | January 24 | January 31
Total***
Agricultural | N/A | N/A | N/A | N/A | N/A
Index | N/A | N/A | N/A | N/A | N/A
Energy | N/A | N/A | N/A | N/A | N/A
Metals | N/A | N/A | N/A | N/A | N/A
OTHER** | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, January 31 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**OTHER variable includes the following products: Multi-Commodity, Environmental, and Freight.
***These numbers are estimates.
****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: darrell_schoolcraft__7783__imbalsumm0107
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled
1 | 0 | 0 | 24670 | 23460
2 | 0 | 0 | 24668 | 23536
3 | 0 | 0 | 24650 | 24000
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
2001-05-31 00:00:00 | Balance | -1027135 |  | -464064
2001-07-03 00:00:00 | Balance
 | Contract #
 | 22864 |  |  |  | -58339.66 | Zia
 | 20379 |  |  |  | -51695.87 | Grayco/Artesia
 | 21459 |  |  |  | 10570.56
 | 26357 |  |  |  | 44144.84 | [NAME]
 | 21544 |  |  |  | 61340.16 | [NAME], [NAME]
 | 24532 |  |  |  | -635539.74 | 500211,500212,500219,500230 - Coburn points
 | Duke
Spreadsheet: e79caab7-efaa-495b-8ba3-8ba174b16149
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2415 | 6315 | [NAME] | Comerford | GBR | 9 | 01:01:08 | 00:00:43 | 03:19:21 | [NAME] | 02:09:30 | 1 | [NAME]
2415 | 12004 | Elise | Caillet | FRA | 10 | 01:08:24 | 00:01:40 | 03:41:48 | 00:01:08 | [NAME] | 2 | 07:13:00
2415 | 6588 | [NAME] | Bayley | GBR | 8 | 01:00:29 | 00:00:40 | 03:35:04 | 00:01:30 | [NAME] | 3 | 07:20:02
2415 | 12005 | Gwenola | Joubel | FRA | 84 | [NAME] | 00:01:58 | 04:01:40 | 00:01:00 | [NAME] | 4 | 07:54:27
2415 | 12006 | Laurence | Prigent | FRA | 87 | 01:17:52 | [NAME] | 03:52:09 | 00:01:40 | 02:52:44 | 5 | 08:06:12
2415 | 12007 | Jocel | Guillemois | FRA | 42 | 01:26:22 | 00:03:01 | 04:12:57 | 00:03:09 | 03:24:15 | 6 | 09:09:44
Spreadsheet: 848769d1699401304-list-of-all-worksheet-names-in-same-workbook-cash_test1
Sheet: Oct 16-Oct 21

 | Date | Total | Cash Paid in Payroll | Net Balance C - D | Cash Paid to Employee | Item #
 | 2023-10-16 00:00:00 | 150 | 741 |  | [NAME] | 238, 260
 | 2023-10-17 00:00:00 | 250 | 96 |  | Smith | 236, 239, 267
 | 2023-10-18 00:00:00 | 165 | 57 |  | [NAME] | 226, 239
 | 2023-10-19 00:00:00 | 155 |  |  |  | 237, 275
 | 2023-10-20 00:00:00 | 455 |  |  |  | 231, 242, 243, 274, 278
 | 2023-10-21 00:00:00 | 450 |  |  |  | 240, 241, 262, 272, 275
Spreadsheet: 829918d1684527849-supplier-delivers-any-part-number-to-prague-or-paris-supplier-delivers-any-part-number-to-prague-or-paris
Sheet: Sheet1

 | City | Supplier | Part Number | Required Result |  | Required result: Return "yes" if [NAME] delivers any Part Number to Prague or Paris
 | Prague | A | 1 | yes
 | London | B | 2 | no
 | Prague | F | 3 | yes
 | Paris | C | 4 | yes
 | Berlin | A | 5 | yes
 | Berlin | E | 6 | no
 | London | A | 7 | yes
 | Milan | D | 8 | no
 | Zurich | E | 9 | no
 | Milan | C | 10 | yes
Spreadsheet: 794710d1662233387-keep-running-totals-of-stock-on-hand-for-multiple-part-numbers-sample
Sheet: Sheet1

Material | Unrest | Open Qty
107526A1-02 | 0 | 2
107525A1-02 | 0 | 2
106273K1-02 | 30 | 60
106272K1-02 | 60 | 60
105304K1-01 | 215 | 60
106273K1-01 | 421 | 120
107526A1-02 | 0 | 1
107525A1-02 | 0 | 1
106272K1-02 | 60 | 90
106273K1-02 | 30 | 60
106272K1-02 | 60 | 60
103400K1-01 | 1058 | 80
103402K1-01 | 1072 | 80
105961K1-01 | 658 | 150
105304K1-01 | 215 | 140
105800K1-03 | 242 | 64
105799K1-03 | 424 | 64
105798K1-04 | 608 | 144
105960K1-02 | 884 | 150
106272K1-02 | 60 | 30
106272K1-02 | 60 | 30
106273K1-02 | 30 | 30
Spreadsheet: 822657d1679477242-need-help-what-formula-use-in-ms-2019-for-filter-sample
Sheet: Sheet1

Order# | PO# |  | Abc | Date | Line1 | Line2 | [NAME] | Balance
123 | 111 |  |  |  |  |  |  | 500
124 | 222 |  |  |  |  |  |  | 500
520 | 333 |  |  |  |  |  |  | 0
200 | 1A |  |  |  |  |  |  | 150
ABC | A |  |  |  |  |  |  | 111
Expected Results
 | PO# | Balance
123 | 111 | 500
124 | 222 | 500
200 | 1A | 150
ABC | A | 111
Spreadsheet: 172557d1344260093-if-a3-has-a-number-in-show-a1-details-in-z1-test
Sheet: 2012-13 Initial List

Fencing Renewals for 2012-13 |  |  |  |  |  | [NAME] (M) |  |  |  |  |  |  |  |  |  |  |  | [NAME]) O/L Panels |  |  |  |  | post inserts(EACH) |  |  | RENEW GATES (EACH) |  |  |  |  |  |  |  |  |  |  |  | CLEARING |  |  | PAINTING (L/M) |  |  |  | EXTRAS | NOTES | TOTAL COST NET | COMPLETED DATE | CHECKED BY | INVOICE DATE
DW |  | address | client | phone number | description | 1.8m high post and base o/lap | 1.5m high post and base o/lap | 1.2m high post and base o/lap | 1.m high post and base o/lap | .9m high post and base o/lap | 3ft 6" o/lap on top of wall | 2m high post and rail h+m | 1.8m high post and rail h+m | 1.5m high post and rail h+m | 1.2m high post and rail h+m | 1.m high post and rail h+m | .9m high post and rail h+m | 1800 | 1500 | 1200 | 1000 (2ft 6") | 900 | 1ft | 2ft | 3ft | 2m high gate | 2m high gate  posts | 1.8m high gate | 1.8m high gate  posts | 1.5m high gate | 1.5m high gate  posts | 1.2m high gate | 1.2m high gate  posts | 1m high gate | 1m high gate  posts | .9m high gate | .9m high gate  posts | old fencing | low level privets | high level privets | 3FT ONE SIDE | 3FT BOTH SIDE | 6FT ONE SIDE | 6FT BOTH SIDE
COST PER UNIT |  |  |  |  |  | 59 | 46 | 39.5 | 39 | 38 | 40 | 60 | 55 | 55 | 54 | 42 | 39.5 | 24 | 24 | 20 | 20 | 20 | 20 | 22 | 26 | 140 | 40 | 120 | 40 | 120 | 40 | 110 | 40 | 110 | 40 | 110 | 40 | 10 | 10 | 15
TOTAL NUMBER OF  UNITS
DW002785NEW |  | 5 Agnes St Higher Broughton Salford M7 4fn M7 4FN | [NAME] | [PHONE]
DW002781 |  | 1 Agnes Street Higher Broughton Salford M7 4xj M7 4XJ | [NAME] | [PHONE]
DW002782 |  | 2 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Miss Blore
DW002783 |  | 3 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Mr [NAME] | [PHONE]
DW002784 |  | 4 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Mr Lyons | 079087 10321
DW002786 |  | 6 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | [NAME]
DW002787 |  | 7 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Mr And [NAME] | [PHONE]
DW002788 |  | 8 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Mr [NAME] | [PHONE]
DW002789 |  | 9 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | [NAME] | [PHONE]
DW0027810 |  | 10 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | [NAME] | [PHONE]
DW0027811 |  | 11 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | [NAME]
DW0027812 |  | 12 Agnes Street Higher Broughton Salford M7 4fn M7 4FN | Miss [NAME] | [PHONE]
Spreadsheet: chris_stokley__3994__Closing 061901 mkt cert Dec
Sheet: Dec Debtor

 | Certification for Market Settlement June 19, 2001
 | For the Trade Month of December 2000
ISO Creditors to whom amounts are Owed:
# | Customer Name | Trade Month |  |  | Amount Owed | % of total owed to Creditors
 | Total Due to 49 SCs (Creditors) |  |  |  | 1471113049.64
Amounts owed by [NAME] that remain unpaid:
Preliminary and final invoices were provided in March's certification.
# | Customer Name | Date | Inv # | Type | Unpaid Balance | % of total due from Debtors
1243 | California Power Exchange | 2001-02-27 00:00:00 | 14163 | Mkt | 1430114437.65
1243 | California Power Exchange | 2001-03-15 00:00:00 | 14323 | Mkt | 54594957.95
2769 | California Power Exchange | 2001-02-27 00:00:00 | 14126 | Mkt | 12171363.36
2769 | California Power Exchange | 2001-03-15 00:00:00 | 14286 | Mkt | 235652.69
1011 | Pacific Gas and Electric | 2001-02-27 00:00:00 | 14183 | Mkt | 11394577.6
1008 | Salt River project | 2001-03-15 00:00:00 | 14345 | Mkt | 1738371.48
1010 | Southern California Edison | 2001-03-15 00:00:00 | 14344 | Mkt | 3337442.11
2465 | Strategic Energy | 2001-03-15 00:00:00 | 14298 | Mkt | 823115.32
 | Total Due From SCs (Debtors)
 | Summary of activity for Trade Month of December 2000:
 | Due from SCs
 | Preliminary Invoices |  |  |  | 1503186210.21
 | Final Invoices |  |  |  | 72817565.78
 | Total Invoiced
 | Collected 3/5/01 |  |  |  | 46371366.56
 | Applied against Nov-00 Market AR 3/5/01 |  |  |  | -352934.19
 | Collected 3/9/01 |  |  |  | 1095680.05
 | Collected 3/22/01 |  |  |  | 4668657.91
 | Collected 4/20/01
 | Total Collected
 | Applied against Dec-00 Market AP 3/22/01
 | Applied against Jan-01 Market AP 4/9/01 |  |  |  | 21483.12
 | Applied against Nov-00 Market AP 4/20/01 |  |  |  | 2463.45
 | Applied against Jan-01 Market AP 4/20/01 |  |  |  | 21.04
 | Applied against Jan-01 GMC 4/20/01
 | Applied against Jan-01 Market AP 4/27/01 |  |  |  | 118120.46
 | Applied against Feb-01 Market AP 5/10/01 |  |  |  | 1476860.84
 | Applied against Feb-01 Market AP 5/17/01 |  |  |  | 1284.97
 | Applied against Mar-01 Market AP 5/31/01 |  |  |  | 1202.39
 | Applied against Feb-01 Market AP 6/19/01 |  |  |  | 6534.54
 | Total Adjustments
 | Balance Due from SCs
 | Due to SCs
 | Preliminary Invoices
 | Final Invoices |  |  |  | 81563642.97
 | Total Invoiced
 | Paid 3/7/01 |  |  |  | 45426874.33
 | Paid 3/97/01 |  |  |  | 1095680.05
 | Paid 3/23/01 |  |  |  | 4660365.5
 | Paid 3/27/01 |  |  |  | 8292.41
 | Paid 4/23/01 |  |  |  | 1243.61
 | Total Paid
 | Applied against Dec-00 GMC 3/7/01 |  |  |  | 554063.09
 | Applied against Dec-00 GMC 3/9/01 |  |  |  | 1911.84
 | Applied against Dec-00 GMC 3/22/01 |  |  |  | 35583.11
 | Applied against Dec-00 Market AR 3/22/01
 | Cancelled invoices 3/22/01
 | Applied against Jan-01 Market [NAME]
 | Applied against Jan-01 Market AR 5/17/01 |  |  |  | 217315.41
 | Applied against Mar-01 Market AR 5/31/01 |  |  |  | 2962776.9
 | FERC ordered reduction 5/31/01 |  |  |  | 1291405.14
 | Total Adjustments
 | Balance Due to SCs
Spreadsheet: vkaminski__40781__book summary
Sheet: summary

 | MtM |  |  |  |  | Positions
 |  |  |  |  | FOB Book
LNG Book |  |  |  |  | Elba Book
Ship Book |  |  |  |  | Total
LNG Freight Hedge Book
Total |  |  |  |  | Ship Book
HG Charter not covered |  |  |  |  | LNG Freight Hedge Book
Net Total w/o uncovered cost |  |  |  |  | Total |  | <----Represents Boil Off and Elba Fuel
Current Book Assumptions
1.  All ship costs are currently shown as fixed  amounts per the EI model.
2. All FOB curves are per EI
3. [NAME] curve is Henry Hub Flat plus 2
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-006,087

 |  |  |  |  |  |  |  | 9-006   9-087   9-110
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 167339d1341953386-excel-2007-average-function-used-to-calculate-percentage-when-category-quantities-change-nmh-arch-score-sheetr1
Sheet: Sheet2

 |  |  |  |  |  |  |  | Project Scorecard     Architect
 | Date:
 | Project name:
 | Project Capital number:
 | Project HP number:
 |  |  |  |  |  |  |  | Points (1-5) | Percentage
 | General Performance
 | 1 | Regulatory Agency Coordination |  |  |  |  |  | 4
 | 2 | Performance of sub-consultants |  |  |  |  |  | 3
 | 3 | Overall performance |  |  |  |  |  | 4
 | Include |  |  |  |  |  | Subtotal: | 11 | 0.7333333333333333
 | Programming and Design
 | 4 | Communication with end users
 | 5 | Familiar with project site
 | 6 | Knowledge of clinical needs & requirements
 | 7 | Maintain design schedule
 | 8 | Coordination of inter-discipline documents
 | 9 | Completeness and accuracy of contract documents
 | 10 | Completeness of scope
 | 11 | Add service request 'syndrome'
 | 12 | [NAME]
 | 13 | BIM
 | 14 | Budget
 | Exclude |  |  |  |  |  | Subtotal: | 0 | 0
 | Interior Design
 | 15 | Quality of design |  |  |  |  |  | 5
 | 16 | Conformance with NMH brand |  |  |  |  |  | 5
 | 17 | Conformance with NMH standards |  |  |  |  |  | 5
 | Include |  |  |  |  |  | Subtotal: | 15 | 1
 | Construction Administration
 | 18 | RFI response |  |  |  |  |  | 5
 | 19 | Shop drawing review |  |  |  |  |  | 5
 | 20 | Coordination with trades |  |  |  |  |  | 5
 | 21 | Continuity of staff throughout project |  |  |  |  |  | 2
 | Include |  |  |  |  |  | Subtotal: | 17 | 0.85
 | Closeout process
 | 22 | Punchlist |  |  |  |  |  | 5
 | 23 | Review of closeout documents |  |  |  |  |  | 3
 | 24 | Stabilization input and response |  |  |  |  |  | 3
 | 25 | Commissioning agent assessments |  |  |  |  |  | 5
 | Include |  |  |  |  |  | Subtotal: | 16 | 0.8
 |  |  |  |  |  |  | Total: |  | 59
 |  |  |  |  |  |  | Percentage: |  | 0.8458333333333334
Spreadsheet: 882614d1730993771-income-tax-using-lambda-and-let-functions-tax-income-using-lambda-and-let
Sheet: Sheet1

 |  | $ |  | $ |  | Rates |  | $
 | From | 0 | to | 100 | multiply by rate | 0 | Deduct | 0
 | From | 100.01 | to | 300 |  | 0.2 |  | 20
 | From | 300.01 | to | 1000 |  | 0.25 |  | 35
 | From | 1000.01 | to | 2000 |  | 0.3 |  | 85
 | From | 2000.01 | to | 3000 |  | 0.35 |  | 185
 | From | 3000.01 | and above |  |  | 0.4 |  | 335
 |  |  |  |  | Desired Solution
 | Employee Name | Salary | Allowable Deduction | Taxable Income | Income Tax
 | [NAME] | 190 |  |  | 16.29
 | Kelly | 150 |  |  | 8.650000000000002
 | Gloria | 150 |  |  | 8.650000000000002
 | Amanda | 170 |  |  | 12.47
 | [NAME] | 170 |  |  | 12.47
 | [NAME] | 170 |  |  | 12.47
 | Tonya | 170 |  |  | 12.47
 | [NAME] | 170 |  |  | 12.47
 | Total
 | TIN or Personal ID of Employee | Employed From date | Employed To date | Current Salary, wages, fees, Commissions etc (regular earnings) |  | Other Exemptions on Current Salary, wages, fees, Commissions etc (regular earnings) |  | Current Overtime |  | Current Disabled persons credit |  | Current Elderly person credit |  | Cumulative Bonus (from last tax period
 |  |  |  | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL
 | 08-965660 G73 | 01/04/2021 | To Date | 190 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-2101012 E39 | 01/04/2021 | To Date | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-2046598 J39 | 01/04/2021 | To Date | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 58-364250 B27 | 01/10/2021 | To Date | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-2014259H35 | 2024-01-02 00:00:00 | To Date | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-719754 S03 | 01/09/2021 | To Date | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-2052740 K03 | 01/10/2022 | To Date | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08-2144816S66 | 2024-02-08 00:00:00 | To Date | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 822987d1679631905-listing-the-winner-s-of-a-golf-skin-in-separate-cell-golf
Sheet: MONEY

Player | CC |  | TL |  | CR |  | SH |  |  | WINNERS
A | 5 |  | 4 |  | 5 |  | 5 |  |  |  |  |  |  |  |  | DAILY
B | 3 |  | 2 |  | 3 |  | 5 |  |  |  |  |  |  |  | WINNERS | 21
C | 3 |  | 2 |  | 3 |  | 5
D | 3 |  | 4 |  | 4 |  | 4
E | 4 |  | 3 |  | 5 |  | 3
F | 2 |  | 4 |  | 3 |  | 2
G | 6 |  | 6 |  | 3 |  | 6
Spreadsheet: 801237d1666130053-convert-ip-to-corresponding-octets-binary-ip-worksheet
Sheet: Sheet1

 | Position | 8th | 7th | 6th | 5th | 4th | 3rd | 2nd | 1st
 | Value | 128 | 64 | 32 | 16 | 8 | 4 | 2 | 1
first | 213 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1
second | 169 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1
third | 94 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0
fourth | 82 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0
 | Enter ip address into each cell marked first through fourth.
 | Then figure out how many of the values fit in to each number. |  |  |  | Manual way of doing what should be automatically filled in when
 | For example 107, there can be no first value as it is higher than |  |  |  | entering the IP address numbers in rows 5 through 8 column B.
 | 107 so you would put a zero into that box. Then ask yourself |  |  |  | Subsequently would like to get IP address in column B filled in when
 | can a second value of 64 fit into the first number, if so place a |  |  |  | placing 1' and 0s in colums C through J for subsequent rows 5 through 8
 | one into the box and subtract 64 from 107 and you would be |  |  |  | Probably have to make a second layout above to do second part.
 | left with 43, now would the 6th value (32) fit into what is left?
 | yes, so you would place a one into the box. Continue on until
 | you've completed the first IP number and then move to the next
 | and do the same until you have all boxes either with a 0 or a 1.
 | =SUMPRODUCT($C$4:$J$4,$C5:$J5)
TMS
 |  | =MID(DEC2BIN($B5,8),COLUMNS($C5:C5),1)
[NAME]
Spreadsheet: john_griffith__15858__Daily Settles
Sheet: Sheet1

Today's Settles
$5 Swaption on CY 02 |  | 0
Cal 02 |  | 3.439
$6 Calls on Q1 02 |  | .07 @ .09 | 13 delta
$5.25 Calls on Cal 02 |  | .145 @ .165 | 21 delta
Jan 02 3.50 Calls |  | .43 @ .45 | 55 delta
Dec 01 $2.25 Puts (Gas Daily) |  | .035 @ .055 | -8 delta
Dec 01 $3.50 Calls (Gas Daily) |  | .345 @ .365 | 50 delta
Spreadsheet: 870552d1717056264-transpose-with-filter-to-create-new-data-row-transpose-testing-aligw
Sheet: New Worksheet

 | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10
506008 | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10 | Skill 11 | Skill 12 | Skill 13 | Skill 14 | Skill 15 | Skill 16 | Skill 17 | Skill 18 | Skill 19 | Skill 20 | Skill 21
521813 | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10 | Skill 11 | Skill 12 | Skill 13 | Skill 14 | Skill 15 | Skill 16 | Skill 17 | Skill 18 | Skill 19 | Skill 20 | Skill 21 | Skill 22 | Skill 23 | Skill 24 | Skill 25 | Skill 26 | Skill 27 | Skill 28 | Skill 29 | Skill 30 | Skill 31 | Skill 32 | Skill 33 | Skill 34 | Skill 35 | Skill 36 | Skill 37 | Skill 38 | Skill 39 | Skill 40 | Skill 41 | Skill 42 | Skill 43 | Skill 44 | Skill 45 | Skill 46 | Skill 47 | Skill 48 | Skill 49 | Skill 50 | Skill 51 | Skill 52 | Skill 53 | Skill 54 | Skill 55 | Skill 56 | Skill 57 | Skill 58 | Skill 59 | Skill 60 | Skill 61 | Skill 62 | Skill 63 | Skill 64 | Skill 65 | Skill 66 | Skill 67 | Skill 68 | Skill 69 | Skill 70 | Skill 71 | Skill 72 | Skill 73 | Skill 74 | Skill 75 | Skill 76 | Skill 77 | Skill 78 | Skill 79 | Skill 80 | Skill 81 | Skill 82 | Skill 83 | Skill 84 | Skill 85 | Skill 86 | Skill 87 | Skill 88 | Skill 89 | Skill 90 | Skill 91 | Skill 92 | Skill 93 | Skill 94 | Skill 95 | Skill 96 | Skill 97