tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 129004d1321396683-unable-to-make-lines-on-a-graph-move-through-an-arc-whilst-maintaining-y-intercept-suspension-analysis
Sheet: Springs

 |  |  | Front |  | Rear |  |  |  | y | x | m | c
Spring rate |  |  | 55000 |  |  |  | N/m |  | Pushrod
Spring mount distance from pivot |  |  | 0.07 |  |  |  | m
Spring mount angle |  |  |  | 70 |  |  | rad/deg
Lower control arm distance |  |  |  |  |  |  | m |  | 0.2
Rocker mount inboard |  |  | 0.2 |  |  |  | m
Rocker mount top of chassis |  |  | 0.4 |  |  |  | m |  | Rocker arm 1
Spring mount point |  |  | 0.3 |  |  |  | m
1st rocker arm angle from chassis |  |  |  | 45 |  |  | rad/deg
2nd rocker arm angle from chassis |  |  |  | 45 |  |  | rad/deg |  | Rocker arm 2
Motion ratio calculation
Motion Ratio (wheel travel/spring travel)
Angle of pushrod to wishbone |  |  |  |  |  |  | rad/deg |  | Spring
Angle of rocker arm 1 to pushrod |  |  |  |  |  |  | rad/deg
Ratio of arm 1 to arm 2 |  |  |  |  |  |  |  |  | 0
Angle of shock to rocker arm 2 |  |  |  |  |  |  | rad/deg
Total motion rate
Wheel rate |  |  |  |  |  |  | N/m
Dimensions
Pushrod |  | m
Rocker arm 1 |  | m
Rocker arm 2 |  | m
Spreadsheet: 741040d1626783355-cumulative-sum-and-if-preorder-examples
Sheet: example_1

Example 1.
internal_no | order_qty | preo_qty | new_OQ |  | preor_qty_exists? |  | cumulative_sum |  | cum_positive? |  | xxx |  | final
BO [PHONE] | 5 |  | 5
BO [PHONE] | 5 |  | 5
BO [PHONE] | 0 | 20 | 20
BO [PHONE] | 5 | 20 | 0
BO [PHONE] | 0 | 20 | 0
BO [PHONE] | 5 | 20 | 0
BO [PHONE] | 5 | 20 | 0
BO [PHONE] | 5 | 20 | 0
BO [PHONE] | 0 | 20 | 0
BO [PHONE] | 5 | 20 | 5
BO [PHONE] | 0 | 20 | 0
BO [PHONE] | 5 | 20 | 5
BO [PHONE] | 0 | 20 | 0
BO [PHONE] | 5 | 20 | 5
BO [PHONE] | 5 | 20 | 5
Total
Spreadsheet: 715860d1611891023-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Projection

Note mensuelle: | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes
 |  |  | * |  | * |  |  |  |  |  |  |  |  |  | *
 |  |  | * |  | *
Sommaire estimé | Mois dernier | Ce mois-ci
Date début
Date fin |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00
Solde de départ (peut modifier si nécessaire) |  |  | 25320
Revenu net
Dépenses
Paiement avancé Dépense |  |  | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350
Solde final (peut modifier si nécessaire)
Solde de fermeture
Tout +/- si besoin pour balancer
Revenus (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Autre
Crédit Solidarité Qc
Intérêt Banque
Paye travail
Paye vacance
Remb. Impot Canada
Remb. Impot Québec
[NAME]. prêt fam./ami
Remb. TPS
Retrait placement CÉLI
Retrait placement REER
Dépenses (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Assurance auto
Assurance habitation
Autre
Divertissement
[NAME]/chauffage
Épicerie
Essence
Facture médicament
Forfait cellulaire
Impôt retenu Canada
Impôt retenu Québec
Internet
Logement
Paiement avance
Permis conduire
Plaque immatriculation
Prêt famille/amis
[NAME]. Commerçant
Réparation / entretien auto
Restaurant
[NAME] (thérapeute divers)
Transfert cpt. Ép./Inv./Urg.
Vacance/voyage
 | Past | Actual | Past
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR
FT
PL
UR
Spreadsheet: 769502d1645562929-countif-based-on-column-heading-countif_example
Sheet: Sheet1

Animals | Fruits | Bevarages | Colors |  |  |  | Coulum Header | Fruits
Turkey | Apple | Milk | Red |  |  |  | Value | Apple
Rooster | Watermelon | Tea | Yellow |  |  |  | Result | 3
Hen | Orange | Coffee | Blue
Sheep | Pear | Water | [NAME]
Rabbit | [NAME] | Juice | Orange
Pig | [NAME] | Energy drink | Green |  |  |  | The formula needs to look for a specific header name due to the amount of columns in the actual sheet.
Parrot | Nectarine | Cocktails | Violet |  |  |  | I want to be able to update the column header and value to quickly get the result without changing the formula.
Horse | Grape | Milkshake | Black
Rooster | Apple | Water | Red
Hen | Watermelon | Juice | Yellow
Sheep | Orange | Energy drink | Blue
Rabbit | Pear | Juice | Green
Pig | [NAME] | Energy drink | Violet
Parrot | Apple | Cocktails | Yellow
Spreadsheet: 56699fb9-2e4d-41de-beed-3b9e5a1ec19d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259307 | 16444 | [NAME] | Onisseit | GER | 1081 | 00:55:22 | 00:06:42 | 03:51:33 | [NAME] | 02:06:34 | 1 | 07:08:18
259307 | 8131 | Tiare | Lund | NZL | 1082 | 00:55:50 | 00:08:20 | 03:59:36 | 00:10:41 | 02:16:33 | 2 | 07:31:01
Spreadsheet: 141748d1329420722-sorting-based-on-two-columns-chandramohan19
Sheet: Copy of date trim for 2000b

START_DATE | END_DATE | TYPES | RECIPIENT | CODE | Result
2000-04-27 00:00:00 | 2000-05-13 00:00:00 | PP | VE421113 | 7
2000-05-14 00:00:00 | 2000-07-18 00:00:00 | MM | VE421113 | 10
2000-07-19 00:00:00 | 2000-08-20 00:00:00 | FF | VE421113 | 17
2000-08-26 00:00:00 | 2000-10-13 00:00:00 | MM | YN599321 | 10
2000-10-14 00:00:00 | 2000-11-16 00:00:00 | PP | YN599321 | 17
2000-01-01 00:00:00 | 2000-02-03 00:00:00 | MM | WA998123 | 7
2000-02-05 00:00:00 | 2000-04-25 00:00:00 | FF | WA998123 | 17
2000-01-27 00:00:00 | 2000-02-24 00:00:00 | PP | ZZ072111 | 7
2000-04-01 00:00:00 | 2000-05-03 00:00:00 | FF | ZZ072111 | 10
2000-03-16 00:00:00 | 2001-05-18 00:00:00 | PP | WE034999 | 10
2000-05-19 00:00:00 | 2000-08-15 00:00:00 | MM | DBX85123 | 17
2000-04-10 00:00:00 | 2000-05-12 00:00:00 | FF | DBX85124 | 10
Spreadsheet: sally_beck__33987__MgmtSum-Q201-Global-0412
Sheet: AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS
TOT_ALLOCATION | 2nd QUARTER 2001  ALLOCATED EXPENSES
2000-12-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | [NAME]
 | Crude & Products |  | 0 | 0 |  |  |  |  |  |  | 10003.704
COAL | Coal |  |  | 0 |  |  |  |  |  |  | 3401.979
 | Vessel Trading |  |  |  |  |  |  |  |  |  | 0
SO2 | Emissions |  |  | 0 |  |  |  |  |  |  | 874.501
WEATHER | Weather |  |  | 0 |  |  |  |  |  |  | 2264.424
INSURANCE | Global Risk Markets |  | 0 | 0 |  |  |  |  |  |  | 814.461
ECT_INV_IRFX | Financial Trading |  |  | 0 |  |  |  |  |  |  | 2141.165
 | Freight Markets |  | 0 | 0 |  |  |  |  |  |  | 169.846
 | LNG |  |  | 0 |  |  |  |  |  |  | 1207.003
 | Puerto Rico |  |  | 0 |  |  |  |  |  |  | 573.065
 | Finance and Structuring |  |  | 0 |  |  |  |  |  |  | 70.366
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  |  | 474.024
 | Subtotal Commercial
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group Allocated to Teams |  | 0 | 0
 | Total
Spreadsheet: 1ee60d9e-81b8-4db1-8aef-5022d36c8eca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 4. PERSONAL FINANCE COMMITMENTS By Purpose (Fixed Loans): Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New motor cars and station wagons ; |  |  | Original | A2413473X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Used motor cars and station wagons ; |  |  | Original | A2413474A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Total motor vehicles ; |  |  | Original | A2413475C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Individual residential blocks of land ; |  |  | Original | A2413476F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Unsecured finance for owner occupation ; |  |  | Original | A2413477J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Debt consolidation ; |  |  | Original | A2413478K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413479L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413480W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413481X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 103904d1301566930-de-duping-while-keeping-content-of-other-columns-sample
Sheet: Sheet1

email | group
[EMAIL] | family
[EMAIL] | boating
[EMAIL] | fishing
[EMAIL] | cooking
[EMAIL] | 50+
[EMAIL] | miami
[EMAIL] | family
[EMAIL] | anime
[EMAIL] | cooking
[EMAIL] | 20+
[EMAIL] | family
[EMAIL] | gardening
[EMAIL] | new york
[EMAIL] | books
Spreadsheet: 65392d1266081383-calculate-percentage-based-off-2-columns-717923-calculate-percentage-based-off-2-columns
Sheet: Sheet1

Header1 | State
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Arizona
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Texas
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Test | Arizona
Test | Kentucky
Test | Tennessee
Test | Georgia
Test | Texas
Test | Florida
Spreadsheet: 5ab1d06d-08f4-445d-99d7-6877c887b894
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 8 Passive components 8.3 Resistors (including R networks) 8.3.2 Variable resistors 8.3.2.12 Motor potentiometers
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Bourns GmbH | Germany | Sauerlach | 82054 | A5.202
2 | Eurofarad | France | PARIS CEDEX 11 | 75540 | B5.312
Spreadsheet: 775228d1648914100-copy-values-from-one-sheet-to-another-sheet-lookup
Sheet: NEW_TOTAL

LAST DATE =
999- 62 | STAN |  | 36520.98
999- 63 | STAN CODE1 |  | 34.91
999- 64 | LYNN |  | 6708.5
999- 65 | LYNN CODE1 |  | 67.36
999- 66 | NEW FUND |  | 2586741.68
999- 93 | ADVISORY |  | 121117.56
999-55 | LYNN NEW FUND |  | 805820.1
999-78 | LYNN CSTM |  | 134000.71
999-48 | STAN NEW FUND |  | 120084.71
999-67 | CODE2 |  | 84506.85
TOTAL | TOTAL |  | 4603170.36
Spreadsheet: 881895d1730121843-vlookup-if-functions-flatb-example
Sheet: Master List

When sorting tools by tool number, custom sort, add levels, first D then E, sort anything that looks like a number as a number. When adding a new tool number drag formulas down from row above for column D & E. | FORME NO | MACHINE CODE | 1st Sort Level | 2nd Sort Level | CUSTOMER | REFERENCE | PRODUCT CODE | MACHINE | LOCATION PREFIX | LOCATION No | NOTES
 | A1 |  |  |  | APPLE | JELLY | ABC123456 | PLAT
 | A100 |  |  |  | ARGOS | BUMP | ABC123457/A | MARU
 | A102 | R |  |  | ANGELS | COFFIN | ABC123458 | ROLL
 | A11 |  |  |  | ARGOS | SOFA | ABC123459BA | MARU
 | A112 | R |  |  | ASTRA | TV | [NAME] | ROLL
 | A3 |  |  |  | AMAZON | FRIDGE | ABC123461C | MARU
Spreadsheet: 1abeb744-2d3e-4c4a-921f-d6c04d8f5fec
Sheet: Funding Source codes

SFY 2015 STATE CODE SHEET
SFY 2015 STATE EDRS-UFARS codes crosswalk
UFARS Finance Dimensions (FIN) to EDRS Funding Source Codes (FSC)
UFARS FIN | EDRS FSC | [NAME]
740 | A | Program Aid - Regular School Year
740 | C | Alternative Delivery of Specialized Instructional Services - Regulat School Year
741 | c | Part C Infants and Toddlers Birth-2
740 | E | Program Aid - Extended School Year (July-August 2014 and June 2015)
372 | i | Third Party Revenue/Expenditures Extended School Year
372 | j | Third Party Revenue/Expenditures Regular School Year
740 | M | Court Placement (Non-Minnesota Resident) (ENTERED BY MDE)
740 | N | Alternative Delivery of Specialized Instructional Services - Extended School Year
740 | P | Out-of State Tuition (Minnesota Residents with IEP's) (ENTERED BY MDE)
799 | R | Local Collaborative Time Study (LCTS)
756 | U | Full State Payment - Pupils with IEP's (ENTERED BY MDE)
761 | X | Full State Payment - Pupils without IEP's (ENTERED BY MDE)
end of worksheet
Spreadsheet: 1b47caeb-31a0-46f8-9bfc-a2df9aa7a65c
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 |  |  | Permanent Organization Roster
 |  |  |  | Club Name:
 |  |  |  | Post Office:
 |  |  |  | State/Province:
 |  |  |  | Country
Key Number: |  |  |  | Permanent Organization Date:
(for office use only) |  |  |  | District:
 |  |  |  | Number Reported:
 | The new club will receive a club roster from Kiwanis International once the club has been processed.
 | Signed: |  |  |  | Signed:
 |  | Club President or Secretary |  |  |  | TAG Team Member
 | Members (please complete as much as possible)
 |  |  |  |  |  |  | *All Kiwanis International correspondence will be sent to primary address.
 | Salutation | First Name | Last Name | Suffix | Nickname | Gender | *Primary Address | Primary City | Primary  State/Province | Primary  ZIP or Postal Code | Primary Country | [NAME] | Date of birth | Spouse's Name | Primary E-Mail | Recruiter's Name | Membership Status: | From Kiwanis Club of: | Are you a former Service Leadership Programs member? | If yes, which one(s)?
 | Mrs.  Ms.  Mr.  Dr.   Fr.   Etc. |  |  |  |  | Male or Female |  |  |  |  |  |  | (dd/mm/yyyy) |  |  |  | Dual, Seed, or [NAME] |  | Yes or No | CKI, Key Club, Builders Club, K-Kids, Aktion Club
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
Spreadsheet: 860336d1708468719-help-with-formula-example-conditional-formatting-tms
Sheet: Using COUNTIF

Acct. # |  |  |  |  |  |  | State | Yellow | Blue
64655 |  |  |  |  |  |  | CO
976165 |  |  |  |  |  |  | TN
95546 |  |  |  |  |  |  | FL
855 |  |  |  |  |  |  | NY
24656 |  |  |  |  |  |  | OK
2959 |  |  |  |  |  |  | CA
65866353 |  |  |  |  |  |  | WI
6655 |  |  |  |  |  |  | KY
26565
Spreadsheet: 275311d1383442880-pull-text-from-2-columns-based-on-finding-text-in-other-columns-example-1-for-jim
Sheet: Sheet2

 |  | data I would like
 |  | count amount and type of "NO" s by vendor |  |  |  |  | then I need to sum how many times the vendor has a NO
 |  | vendor | PURCHASE ODRER NUMBER | no certs | no mm |  | vendor count
 |  | widgets1 | 56 |  |  |  |  |  | widgets1 | 56 | 1 |  |  | 1
 |  | gadgets2 | 456 |  |  |  |  |  | gadgets2 | 456 | 1 |  |  | 1
 |  | med1 | 12 |  |  |  |  |  | med1 | 12 | 1 | 1 |  | 2
 |  | med2 | 29 |  |  |  |  |  | med2 | 29 |  | 1 |  | 1
 |  | widgets1 | 101 |  |  |  |  |  | widgets1 | 101 | 1 |  |  | 2
 |  | med1 | 12 |  |  |  |  |  | med1 | 12 | 1 |  |  | 3
 |  |  |  |  |  | then graph their total count
Spreadsheet: 727093d1617713506-last-cumulative-value-of-the-table-appears-till-the-end-of-sheet-accounting-module-belinda-original-copy
Sheet: Sheet1

 | Expenditure Type | Expenses Codes | Final Acc. Entry |  | Transaction Type | Double Entry Acc.
Expenses | Building Rent | WG/CR/001 | P & L |  | Debit | Bank
 | Electricity | WG/CR/002 | P & L |  | Credit | Petty Cash
 | Fuel | WG/CR/003 | P & L
 | Internet Charges | WG/CR/004 | P & L
 | Mobile Charges | WG/CR/005 | P & L
 | Statationery | WG/CR/006 | P & L
 | Computers | WG/CR/007 | Assets
 | Furniture | WG/CR/008 | Assets
 | Travelling Costs | WG/CR/009 | P & L
 | Marketing/Advertising | WG/CR/010 | P & L
 | Charitables | WG/CR/011 | P & L
 | Sponsorships | WG/CR/012 | P & L
 | Entertainment | WG/CR/013 | P & L
 | Insurance | WG/CR/014 | P & L
 | Water Bill | WG/CR/015 | P & L
 | Car | WG/CR/016 | Assets
 | Motor Bike | WG/CR/017 | Assets
 | Mobile Phones | WG/CR/018 | Assets
 | Owners Withdrawals | WG/[NAME] | Capital Acc
 | Salaries | WG/CR/020 | P & L
 | Loans Disburesed | WG/CR/021 | Debtors
 | Interest Paid | WG/CR/022 | P & L
 | Petty Cash | WG/CR/023 | Balance Sheet
 | EPF | WG/CR/024 | P & L
 | ETF | WG/CR/025 | P & L
 | Bonus | WG/CR/026 | P & L
Incomes | Document Charges | WG/CR/027 | P & L
 | Loan Capital Recovery | WG/CR/028 | Working Capital
 | Loan Interest Recovery | WG/CR/029 | P & L
 | Donations | WG/CR/030 | Capital Acc
 | Other Incomes | WG/CR/031 | P & L
 | Owners Capital | WG/CR/032 | Equity Capital
 | Third Party Loans | WG/CR/033 | Debt Capital
Spreadsheet: 763481d1642185439-add-value-to-array-add-value-to-array
Sheet: Sheet1

Dates |  |  |  | Need to get: | The value yellow cell needs to be added to the array.
2022-01-01 00:00:00 |  |  | 2022-12-31 00:00:00 | 2022-01-01 00:00:00
2023-02-13 00:00:00 |  | 2022-02-13 00:00:00 |  | 2022-02-13 00:00:00
2022-02-15 00:00:00 |  | 2022-02-15 00:00:00 |  | 2022-02-15 00:00:00
2022-02-15 00:00:00 |  | 2022-03-15 00:00:00 |  | 2022-03-15 00:00:00
2022-02-13 00:00:00 |  | 2022-12-29 00:00:00 |  | 2022-12-29 00:00:00
2022-01-01 00:00:00 |  | 2022-12-31 00:00:00 |  | 2022-12-31 00:00:00
2022-12-29 00:00:00 |  | 2023-02-13 00:00:00 |  | 2023-02-13 00:00:00
2022-12-31 00:00:00 |  |  |  | 2022-12-31 00:00:00
2022-02-15 00:00:00
2022-02-15 00:00:00
2022-03-15 00:00:00
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* |  | <100 | <100 | <100 | 116 | 126 | 114 | 356
FRA | 4756 | 3916 | 2376 | 3036 | <100 |  |  | 14084
IRS- [NAME] | <100 | 178 | 310 | 1601 | 6979 | 10655 | 12355 | 32078
OIS | 214 | 234 | 270 | 848 | 150 |  |  | 1716
VNS |  |  |  |  | <100 | <100 | <100 | <100
Zero Coupon |  |  |  | <100 | <100 | <100 | 120 | 120
TOTAL | 4970 | 4328 | 2956 | 5485 | 7245 | 10781 | 12589 | 48354
Estimated swap transaction volumes, February 8 weekly snapshot, by product type and tenor (millions of USD), all participant types 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 Data Dictionary for product descriptions.
**See Data Dictionary for tenor bucket descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 478350d1472744016-populate-column-from-another-sheet-sales
Sheet: Sales Analysis by Items (Annual

# | Item No. | Quantity | Sales Amt | Gross Profit | Gross Profit % | Supplier
1 | 110023 | 3 | 219.6 | 56.55 | 25.75
2 | 116002 | 20 | 150 | 88 | 58.67
3 | 116003 | 32 | 240 | 142.4 | 59.33
4 | 116010 | 25 | 187.5 | 111.75 | 59.6
Spreadsheet: 540990d1507058992-sum-only-visible-example
Sheet: Sheet3

JOB NAME | VALUE | Main MFG. | Philips Total | DIST'S | CONTRACTORS | Status | FOLLOWUP INFO & NOTES | Quoted By
Warehouse | 130278 |  |  | A | J&J | Not Awarded |  |  |  | Not Awarded | 130278
School 121 | 28979 |  |  | B | RYDALCH | Won |  |  |  | Won
WCL Library | 153405 |  |  | A | CR | Won |  |  |  | Won | 153405
Alta Parking | 233683 |  |  | D | CR | Won
1st West Bank | 249928 |  |  | D | Rydalch | Won
 |  |  |  |  |  |  |  |  |  | Want these to automtically update^
 |  |  | Want to sort by Dist, [NAME], and Quoted by using drop down arrows
Spreadsheet: 85662d1285733026-if-formula-formula-need
Sheet: Sheet1

Sale(Book) | %
250 & above | 1
226 - 249 | (Book/ 500) -4
225 | 0.5
224 &  below | 0
Sales - how to set formula at column c with link paremeter upper.
Name | Sale | %
[NAME] | 258
Angeline | 230
[NAME] | 240
[NAME] | 210
[NAME] | 225
[NAME] | 300
Spreadsheet: 739952d1626100690-highlight-show-differences-between-two-sheets-sample
Sheet: Previous Week

Status | ID | Department | Project Name | Start Date | End Date | Description | Project Manager
In Process | 123 | Sales | Alpha | 2021-07-12 00:00:00 | 2021-08-12 00:00:00 | Provide report | [NAME]
Approved | 456 | IT | Beta | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | Install software | [NAME]
Spreadsheet: 140316d1328703686-excel-2007-pivot-table-headache-example
Sheet: Sheet1

ID | Department | Position Group | Position Title | Gender | MALE | FEMALE
1111 | Avengers | Group 1 | Wolverine | M
2222 | Avengers | Group 1 | Gambit | F
3333 | Avengers | Group 1 | Colossus | M
4444 | Avengers | Group 2 | IceMan | F
5555 | Avengers | Group 2 | IceMan | M
6666 | Xmen | Group 2 | [NAME] | F
7777 | Xmen | Group 2 | Blink | M
8888 | Xmen | Group 2 | Blink | F
9999 | Xmen | Group 1 | Wolverine | M
11110 | Xmen | Group 1 | Wolverine | F
Spreadsheet: 721691d1614819105-what-recipe-can-be-made-from-available-stock-recipe-4-1-
Sheet: Sheet1

 |  | Recipe |  |  | Available Stock |  |  | Remaining Stock
 | Recipe name | Ingredients | Kilogram |  | Ingredients | Kilogram |  | Kilogram
 | [NAME] | Carrot | 500 |  | Carrot | 2000
 |  | Spice | 5 |  | Spice | 25 |  |  |  | Choose your recipe:
 |  | Salt | 5 |  | Salt | 50 |  |  |  | [NAME]
 |  | Onion | 30 |  | Onion | 150
 |  | capsicum | 50 |  | capsicum | 200
 |  | water | 500 |  | water | 3550
 |  | culture | 5 |  | culture | 20
 |  | tea | 5 |  | tea | 40
 |  | total |  |  | total
 | Recipe name | Ingredients | Kilogram
 | [NAME] | Carrot | 1000
 |  | Spice | 25
 |  | Salt | 50
 |  | Onion | 150
 |  | capsicum | 200
 |  | water | 3550
 |  | culture | 20
 |  | tea | 40
 |  | total
Spreadsheet: 725124d1616542479-determine-the-first-non-zero-value-of-a-range-asdf
Sheet: asdf

 |  |  | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8
 | Delivery |  | 1 | 2689283.491215554 | 2913390.44881685 | 4258032.194424627 |  |  |  |  | 1 | [NAME] should return the value of 1
 | Finalisation |  |  |  |  |  | 47237.35 | 47237.35 | 141712.05 |  |  | [NAME] should return the value of 47237