tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 177594d1346354124-tally-chart-using-buttons-mcsmith
Sheet: Sheet2

Day | 1 |  | Day | 2 |  | Day | 3 |  | Day | 4 |  | Day | 5 |  | Day | 6 |  | Day | 7
Date | 2012-08-27 00:00:00 |  | Date | 2012-08-28 00:00:00 |  | Date | 2012-08-29 00:00:00 |  | Date | 2012-08-30 00:00:00 |  | Date | 2012-08-31 00:00:00 |  | Date | 2012-09-01 00:00:00 |  | Date | 2012-09-02 00:00:00
Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count |  | Button | Count
Red |  |  | Red |  |  | Red |  |  | Red | 8 |  | Red |  |  | Red |  |  | Red
Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue |  |  | Blue
Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green |  |  | Green
Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow |  |  | Yellow
Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple |  |  | Purple
Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet |  |  | Violet
White |  |  | White |  |  | White |  |  | White |  |  | White |  |  | White |  |  | White
Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black |  |  | Black
Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received |  |  | Received
Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched |  |  | Dispatched
Invoiced |  |  | Invoiced |  |  | Invoiced |  |  | Invoiced | 1 |  | Invoiced |  |  | Invoiced |  |  | Invoiced
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
Spreadsheet: 857485d1706505298-how-to-join-2-excel-sheets-with-a-common-column-sample-data
Sheet: Sheet1

 | Source File1 |  |  |  | Source File 2 |  |  |  | Destination File (Desired)
 | User | Role |  |  | Role | Privilege |  |  | User | Role | Privilege |  | User | Role | Table2.Privilege
 | A | AA |  |  | AA | 123 |  |  | A | AA | 123 |  | A | AA | 123
 | A | BB |  |  | AA | 345 |  |  | A | AA | 345 |  | A | AA | 345
 | B | AA |  |  | BB | 456 |  |  | A | BB | 456 |  | A | BB | 456
 | C | BB |  |  | BB | 678 |  |  | A | BB | 678 |  | A | BB | 678
 | D | ZZ |  |  | CC | 910 |  |  | B | AA | 123 |  | B | AA | 123
 |  |  |  |  |  |  |  |  | B | AA | 345 |  | B | AA | 345
 |  |  |  |  |  |  |  |  | C | BB | 456 |  | C | BB | 456
 |  |  |  |  |  |  |  |  | C | BB | 678 |  | C | BB | 678
Spreadsheet: 90cd23c9-39c5-49a0-b886-deee4218eb70
Sheet: Sheet1

Unnamed: 0 | 1 | Unnamed: 2 | Unnamed: 3 | 2 | Unnamed: 5 | Unnamed: 6 | 3 | Unnamed: 8 | Unnamed: 9 | 4 | Unnamed: 11 | Unnamed: 12 | 5 | Unnamed: 14 | Unnamed: 15 | 6 | Unnamed: 17 | Unnamed: 18
 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor
B=Blue | B = a | B = 1 |  | B = a | B = 1 |  | B | Y |  | B | G |  | B | Y |  | B | G
G=Green | G = b | G = 3 |  | G = b | Y = 2 |  | G | G |  | G | B |  | G | B |  | G | Y
Y=Yellow | Y = c | Y = 2 |  | Y = c | G = 3 |  | Y | B |  | Y | Y |  | Y | G |  | Y | B
 | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment:
 | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor
 | B | B |  | B | B |  | B | B |  | B | B |  | B | B |  | B | B
1 | G | G | RRF | G | G | NR | G | G |  | G | G |  | G | G |  | G | G
 | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y
 | B | B |  | B = A | B = I |  | B | B |  | B | B |  | B | B |  | B | B
2 | G | Y | NR | G = B | Y = II | RGF | G | Y |  | G | Y |  | G | Y |  | G | Y
 | Y | G |  | Y = C | G = III |  | Y | G |  | Y | G |  | Y | G |  | Y | G
 | B | Y |  | B | Y |  | B | Y |  | B | Y |  | B | Y |  | B | Y
3 | G | G | NR | G | G | RRB | G | G |  | G | G |  | G | G |  | G | G
 | Y | B |  | Y | B |  | Y | B |  | Y | B |  | Y | B |  | Y | B
 | B | G |  | B | G |  | B | G |  | B | G |  | B | G |  | B | G
4 | G | B | NR | G | B | RRB | G | B |  | G | B |  | G | B |  | G | B
 | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y
 | B = A | Y = II |  | B | Y |  | B | Y |  | B | Y |  | B | Y |  | B | Y
5 | G = B | B = I | RGB | G | B | NR | G | B |  | G | B |  | G | B |  | G | B
 | Y = C | G = III |  | Y | G |  | Y | G |  | Y | G |  | Y | G |  | Y | G
 | B | G |  | B | G |  | B | G |  | B | G |  | B | G |  | B | G
6 | G | Y | RRF | G | Y | NR | G | Y |  | G | Y |  | G | Y |  | G | Y
 | Y | B |  | Y | B |  | Y | B |  | Y | B |  | Y | B |  | Y | B
 |  | NOTE: | NR = No Rotation |  |  | The test was conducted on a MYSTERY MOTOR - Manufacturers is Unknown.
 |  |  | RRF = Runs Rough Forward
 |  |  | RRB = Runs Rough Backward
 |  |  | RGF = Runs Good Forward
 |  |  | RGB = Runs [NAME]
Spreadsheet: 0572772c-9a69-489f-9f89-36ac1ffc4cde
Sheet: Sheet1

Unnamed: 0 | COSTS INCURRED BY FAIRVIEW HEALTH SERVICES FOR: | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | (Check one)
 |  | (1)- SPONSORED & DEPARTMENTAL RESEARCH |  |  |  |  | (3)- BILLING REFERENCE # :
 |  | (2)- OTHER |  |  |  |  | (4)- DATE:
 | (5)- FAIRVIEW OPERATING (Billing) DEPARTMENT: |  |  |  | (6)- FAIRVIEW RESEARCH GRANT NUMBER: (a.)
 | OU NUMBER: (a.) |  |  |  | BUDGET REFERENCE: (b.)
 | DEPT NUMBER: (b.) |  |  |  | NAME OF RESEARCH STUDY: (c.)
 | ACCOUNT: (c.) |  |  |  | PRINCIPAL INVESTIGATOR: (d.)
 |  |  |  |  | PURCHASE ORDER NUMBER:  (e.)
 | (7) |  |  |  |  |  | *(H) Fringe Benefit portion recorded in Field Number (10).
 | (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I)
Line | Fairview | Date(s) of | University of Minnesota |  | Description | Hours/ | Salary(only) | Rate*/ | Extended
# | Support Reference | Service | Purchasing Dept. | CUFS Account Number | (If salary, itemize in Columns F, G, & H) | Quantity | SubAccount | Unit Price | Amount
1
2
3
4
5
6
7
8
9
10
 | (8)- ADDITIONAL DESCRIPTION/COMMENTS: |  |  |  |  |  |  | (9)- SUBTOTAL | 0
 |  |  |  |  |  |  | (10)- FRINGE BENEFITS EXPENSE @ | 0.274 | 0
 |  |  |  |  |  |  |  | (11)- TOTAL | 0
 |  |  |  | (Phone Number) | I certify that to the best of my knowledge the effort (labor) cited above is a reasonable estimate of the actual work performed on the grant/project identified in [NAME] (6).
 | (12)- PREPARED BY: |  |  |  | (13)- APPROVED BY: |  |  | DATE:
 | Send to:  (Intercampus Mail) |  | Or | E-Mail to: |  | Fairview Accounting:
 | Fairview Corporate Accounting |  |  | Siiri-Aline Sutphen |  | Date received:
 | 400 Stinson Boulevard NE |  |  | [EMAIL] |  | G/L Posting Date:
 | Attention: Research Accounting |  |  |  |  | G/L Journal Entry Number:
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 6

 | February 14 | February 21 | February 28 | March 7 | March 14
Total Interest Rate* | 5243923 | 6965767 | 8427463.2284 | 5650977
SDs and MSPs** | 3030817 | 3600162 | 4646668.4818 | 3481619 | 4934563.1992
Other | 2213107 | 3365605 | 3780794.7466 | 2169358 | 2762558.3084
Total Cross-Currency | 167389 | 149250 | 173230.185525 | 111789.87
SDs and MSPs | 121900 | 101881 | 115121.67731 | 82185.73 | 119729.38822
Other | 45490 | 47369 | 58108.508215 | 29604.14 | 39616.672579
Total Credit | 412345 | 467688 | 423254.90931 | 487086.3
SDs and MSPs | 253616 | 264859 | 204605.54143 | 260594.2 | 288758.52455
Other | 158729 | 202829 | 218649.36788 | 226492.1 | 236443.54078
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 5823658 | 7582705 | 9023948.323235 | 6249853.17
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 2a42b82e-b2eb-4030-bbbd-3d3d98adb7c4
Sheet: 2.5 oz. ID Millennium

Cost Model
If Westridge wants to make 'x' amount of 2.5 oz. bottle of ID Millenium, how long will it take and how much will it cost?
Input
Batch size (number of bottles) | 240
Output
Number of cases required
Overhead cost
Raw material cost
Labor cost
Total Cost
Revenue ($)
Profit ($)
 | Seconds per batch | Minutes per batch | Hours per batch
Time to complete (sec, min, hour)
 |  |  | plus overnight leak test
Additional Output
Cost per individual step
 | Seconds per batch | Minutes per batch | Hours per batch
Set up cost ($)
Number of operators | 4
Time to set up (sec, min, hour)
Cost to label ($)
Number of operators | 2
Time to label (sec, min, hour)
Cost to fill ($)
Number of operators | 1
Time to fill (sec, min, hour)
Cost to cap ($)
Number of operators | 2
Time to cap (sec, min, hour)
Cost to wait ($)
number of operators | 1
time to wait
Cost to uncap ($)
Number of operators | 1
Time to uncap (sec, min, hour)
Cost to recap ($)
Number of operators | 2
Time to recap (sec, min, hour)
Cost to box ($)
Number of operators | 1
Time to box (sec, min, hour)
Total cost ($)
Total time (hours) |  | plus overnight leak test
Variable Values
Factors included in cost model: |  | Sq. Feet | Rate
overhead (rent per month) |  | 1500 | 155
cost of raw materials per case
Average hourly wage (including taxes and benefits) | 10.52
Average employees working on 2.5 oz ID Millennium | 4
Allowance | 0.1
Time per step
 | Seconds per bottle | Seconds per case (24 bottles) | Fixed Time (sec)
Set up time  (sec)
Time to label  (sec)
Time to fill  (sec)
Time to cap  (sec)
Time to uncap  (sec)
Time to recap  (sec)
Time to box a case  (sec) | N/A
Wait time on conveyer  (sec) | 5
Time per step including allowances
 | Seconds per bottle | Seconds per case (24 bottles) | Fixed Time (sec)
Set up time  (sec)
Time to label  (sec)
Time to fill  (sec)
Time to cap  (sec)
Time to uncap  (sec)
Time to recap  (sec)
Time to box a case  (sec) | N/A
Wait time on conveyer  (sec)
Cost of a bottle of 2.5 oz Millenium ($) |  | 14.74
# in case |  | 24
Average number of bottles labeled per minute | 31.05
Average number of bottles filled per minute | 19.93
Average number of bottles placed on line per minute | 20.32
Average number of bottles uncapped per minute | 20.92
Average number of boxes filled per minute | 2
Cost of Raw Materials ($)
Back Label ($) | 0.02371
Front Label ($) | 0.02857
Bottle ($) | 0.09918
[NAME] ($) | 0.06585
Product ($) Includes waste and overfill | 0.5113
[NAME] ($) | 0.00595
[NAME] ($) one for each 24 bottles | 0.28
Spreadsheet: 155309d1336757130-creating-cells-dependent-on-a-drop-down-list-calc-template
Sheet: Sheet2

 | FW | M | g | [NAME] | mL | mmol | Ratio | CAS
(PPh3)2[C4H6O3)2P-P]RuCp | 23 | -- | 0.213 | -- | -- |  | 1
(PPh3)2[C4H6O3)2P-P]RuCp | 223.343 | -- |  | -- | -- |  | 2
tri(dimethylamino)phosphine | 23.21 | 1 |  | -- |  |  | 1
tri(dimethylamino)phosphine | 120.3 | -- |  | 1 |  |  | 2
Spreadsheet: 164050d1340630486-12-month-rolling-data-in-pivot-ptruntotlast12months
Sheet: Sheet1

Date | Amt
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00 |  |  | Row Labels | Sum of Amt | [NAME]
2010-06-01 00:00:00 |  |  | 2011-06-01 00:00:00 | 2455 | 2455
2010-07-01 00:00:00 |  |  | 2011-07-01 00:00:00 | 2909 | 5364
2010-08-01 00:00:00 |  |  | 2011-08-01 00:00:00 | 3903 | 9267
2010-09-01 00:00:00 |  |  | 2011-09-01 00:00:00 | 2548 | 11815
2010-10-01 00:00:00 |  |  | 2011-10-01 00:00:00 | 3364 | 15179
2010-11-01 00:00:00 |  |  | 2011-11-01 00:00:00 | 4796 | 19975
2010-12-01 00:00:00 |  |  | 2011-12-01 00:00:00 | 2377 | 22352
2011-01-01 00:00:00 |  |  | 2012-01-01 00:00:00 | 3117 | 25469
2011-02-01 00:00:00 |  |  | 2012-02-01 00:00:00 | 2186 | 27655
2011-03-01 00:00:00 |  |  | 2012-03-01 00:00:00 | 2416 | 30071
2011-04-01 00:00:00 |  |  | 2012-04-01 00:00:00 | 2347 | 32418
2011-05-01 00:00:00 |  |  | 2012-05-01 00:00:00 | 4686 | 37104
2011-06-01 00:00:00 |  |  | 2012-06-01 00:00:00 | 3801 | 40905
2011-07-01 00:00:00 |  |  | Grand Total | 40905
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
Spreadsheet: 853893d1703850365-need-help-creating-a-work-hours-and-payment-calculator-work-hours-and-payment-calculator-1-
Sheet: Sheet1

Total Hours Worked
Rate per Hour |  | 10
Payment Due
Payment Received
Paid Work Hours
Unpaid Work Hours
Expecting
Date | Hours Worked | Payment Received
20/12/2023 | 0 | 200
21/12/2023 | 8
22/12/2023 | 3
23/12/2023 | 0 | 200
2023-12-24 00:00:00 | 10
2023-12-25 00:00:00 | 10
2023-12-26 00:00:00
Spreadsheet: 05e3de98-c7f4-4dce-967c-29b3483dacb9
Sheet: Cover Note

 | Pledges & Contributions Reporting - Master File
 | Purpose: |  | Maintain detailed record of all pledges and contributions received by The Global Fund and report summary of position, via TGF external website:
 |  |  | 1. Record contributions received by World Bank trustees on weekly basis;
 |  |  | 2. Add in contributions data received via other sources (RED,…etc);
 |  |  | 3. Report externally, publishing summary report to TGF external website on weekly basis.
 | Accountable: |  | TGF Accounting and Finance Team - Ian Carter
 | Responsible: |  | TGF Accounting and Finance Team - Giles Monnickendam
 | Customer(s): |  | TGF Donor Relations - Oscar Arocha Valerio; all donors and external stakeholders.
 | Input required: |  | World Bank - weekly trust fund report, TGF RED reporting file, www.oanda.com - month-end foreign exchange rates; TGF Donor Relations - updates on new pledges.
 | Overall Process: |  | 1. Receive World Bank trust fund report on contributions received in last week from Lydia Naipanoi (World Bank) on Tuesday/Wednesday.
 |  |  | 2. Copy and paste new transactions data to "WB Contrib Data" tab.
 |  |  | 3. Update any existing trust fund transactions (e.g. transactions moving from "in process" to "complete").
 |  |  | 4. Add in latest RED contributions data from RED reporting file into "RED Contrib Data" tab.
 |  |  | 5. Add in latest contributions data from other sources (Sundry Income Report?) into "Other Contrib Data" tab.
 |  |  | 6. Update exchange rates in "FX-rates" tab at the opening of each new month.
 |  |  | 7. Complete "Report" tab based on latest data (work TBD to automate as much as possible…).
 |  |  | 8. Save a values-only version of file, with only "Pledges" and "Contributions" tabs included.
 |  |  | 9. Publish values-only version to external website.
Spreadsheet: 819639d1677607208-higlight-text-with-certain-parts-in-a-cell-eh_cf-text-with-colon
Sheet: Sheet1

Category: Amb- Continental Meats Definer: Amb Cnti- Jerky COP: Whole G4U: Beef | 1
Category: Amb- Continental Meats Definer: Amb Cnti- Other Ssg COP: Whole G4U: Pork | 1
Category: Amb- Continental Meats Definer: Amb Cnti- Pepperami COP: Whole G4U: Beef | 3
Category: Amb- Continental Meats Definer: Amb Cnti- Pepperami COP: Whole G4U: Pork | 20
Category: Chilled- Continental Meats Definer: Chl Cnti- Peperami COP: Roll G4U: Pork | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: Fillet - Breast G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: [NAME] G4U: Chicken | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 9
Category: Chilled- Finger Fd/Snack Definer: [NAME] -Unctd COP: Pieces - Chunks G4U: Chicken | 69
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Chicken | 109
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Duck | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME]: [NAME] G4U: Mixed Meat Incl Chicken | 3
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Pork | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Pieces - Chunks G4U: Turkey | 1
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Chicken | 3
Category: Chilled- Finger Fd/Snack Definer: [NAME] COP: Not Applicable G4U: Pork | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Bites -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 17
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Bites -Unctd COP: Pieces - Chunks G4U: Chicken | 8
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Diced COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Finger -Brd/Btd COP: Not Applicable G4U: Chicken | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Pops COP: Pieces - Chunks G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Not Applicable G4U: Chicken | 2
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Pieces - Goujons G4U: Chicken | 1
Category: Chilled- Ml Cntr Chicken Definer: [NAME] Ckn- Shapes COP: Pieces - Strips G4U: Chicken | 1
Category: Chilled- Ml Cntr Turkey Definer: [NAME] Tky- Bites -Unctd COP: Pieces - Chunks G4U: Turkey | 1
Category: Frozen- Finger Fd/Snack Definer: Frz Fngr- Kbb/Skwr/Satay COP: [NAME] G4U: Chicken | 23
Category: Frozen- Finger Fd/Snack Definer: Frz Fngr- Other COP: [NAME] G4U: Chicken | 1
Category: Frozen- Ml Cntr Chicken Definer: Frz MC Ckn- Bites -Brd/Btd COP: Pieces - Chunks G4U: Chicken | 3
Category: [NAME]: [NAME] In Mrnd COP: Meatballs G4U: Pork | 1
Category: Frsh Pltry- Chicken AV Definer: [NAME] Ckn- In Mrnd COP: Meatballs G4U: Chicken | 3
Category: Frsh Pltry- Chicken AV Definer: [NAME] Ckn- In Mrnd COP: Portions - Drumsticks G4U: Chicken | 1
Spreadsheet: 672543d1586900604-event-id-to-be-added-to-attendees-data-formula-needed-example
Sheet: Attendees

Invite ID | Addendee ID | Name | Surname | User Country | Event country | Company ID | Company Name | Role | Attended
1 | 2345 | [NAME] | Exotic | Germany | Germany | 234 | Company 1 | Role1 | 1
2 | 999999 | [NAME] | Pitt | Germany | Germany | 345 | Company 2 |  | 1
3 | 6666 | Anna | Wintour | Germany | Germany | 567 | Company 3 | Role2 | 1
4 | 7788 | Trevor | [NAME] | Belgium | Belgium | 555 | Company 5 | Role1 | 1
5 | 1111 | [NAME] | [NAME] | Belgium | Belgium | 777 | Company 6 | Role1 | 1
4 | 2323 | [NAME] | Pitt | Germany | Belgium | 345 | Company 2 |  | 1
6 | 4444 | Tyra | Banks | Japan | Japan |  |  |  | 1
7 | 9898 | Roman | Polanski | Belgium | Belgium |  |  |  | 1
Spreadsheet: 31071d1226810972-average-of-a-coloumn-of-values-based-on-a-critera-for-each-value-on-that-values-row-war-game-example
Sheet: Attacks

 |  |  |  | [NAME] |  |  |  |  |  |  | Attacker Losses
 |  |  |  | Cash | Tanks | Troops | Jets | Turrets | Ships |  | Tanks | Troops | Jets | Ships | Land Conquered | Troops Stationed | Successful | Unsuccessful |  |  | Condition Caches
 | Totals: |  |  | 481485 | 213 | 1167 | 1123 | 836 | 679 |  | 3836 | 7858 | 3936 | 1195 | 287 | 1813 | 4 | 1 |  |  | >0
 | Most Per Individual Attack: |  |  | 180249 | 113 | 543 | 356 | 748 | 344 |  | 1961 | 2427 | 1232 | 326 | 114 | 709
 | Average Per Attack Attempt: |  |  | 96297 | 42.6 | 233.4 | 224.6 | 209 | 135.8 |  | 767.2 | 1571.6 | 787.2 | 239 | 57.4 | 362.6
 | Average Per Successful Attack: |  |  | 96297 | 53.25 | 190.25 | 191.75 | 209 | 143
 |  |  |  | [NAME] |  |  |  |  |  |  | Attacker Losses
 | Attack # | ID # | [NAME] | Cash | Tanks | Troops | Jets | Turrets | Ships |  | Tanks | Troops | Jets | Ships | Land Conquered | Troops Stationed | Successful | Unsuccessful
 | 1 | 1 | Nation 1 | 12345 | 98 | 99 | 89 | 88 | 36 |  | 242 | 1483 | 684 | 221 | 114 | 709 | 1 | 0
 | 2 | 2 | Nation 2 | 54321 | 2 | 4 | 1 | 0 | 0 |  | 0 | 0 | 6 | 6 | 62 | 401 | 1 | 0
 | 3 | 3 | Nation 3 | 96297 | 0 | 406 | 356 | 0 | 107 |  | 1429 | 1926 | 994 | 324 | 0 | 0 | 0 | 1
 | 4 | 4 | Nation 4 | 138273 | 0 | 115 | 349 |  | 344 |  | 204 | 2022 | 1020 | 318 | 52 | 330 | 1 | 0
 | 5 | 5 | Nation 5 | 180249 | 113 | 543 | 328 | 748 | 192 |  | 1961 | 2427 | 1232 | 326 | 59 | 373 | 1 | 0
Spreadsheet: 747946d1631797420-multi-rule-based-selection-distinct-values-with-conditions-klemzy-updated
Sheet: Sheet1

 |  |  |  |  |  | NATIONAL REFEREE
TEAMS | REFEREES |  | Game 1
SLO | ITA 1 |  | Game 2
AUT | ITA 2 |  | Game 3
GER | GER 1 |  | Game 4
FRA | GER 2 |  | Game 5
SWE | SLO 1 |  | Game 6
ITA | SLO 2 |  | Game 7
GBR | SLO 3 |  | Game 8
 | GBR 1 |  | Game 9
 | GBR 2 |  | Game 10 |  |  |  | <- All the referees were used, formula stops working
Spreadsheet: 541133d1507135417-simplex-lp-solver-problem-jp-morgan-chase-atm-problem_solver
Sheet: Sheet1

Location | A | B | C | D | E | F | G | H
Invest? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Used | Available
Amount | 700 | 700 | 700 | 7000 | 7000 | 4200 | 700 | 7000 |  | 28000
ROI | 0.07 | 0.09 | 0.04 | 0.25 | 0.21 | 0.14 | 0.08 | 0.16
Total ROI
Constraints
Total Amount invested <= 28,000
If a location is chosen, at least 700 and no more than 7000 must be invested
Location B cannot be pursued unless Location A is
Location C cannot be pursued unless Location A is
Location D cannot be pursued unless Location B is
Location D cannot be pursued unless Location C is
If [NAME] is chosen, so must Location G (and vice versa)
Locations E and F cannot be pursued at the same time
Spreadsheet: 179805d1347379940-information-auto-fill-vlookup-test-bed
Sheet: Sheet1

Ingredient | Cost | Gross | Recipe | Unit | Cost Per
S/F Flour | 1.7 |  |  |  | #N/A
Caster Sugar | 1.65 |  |  |  | #N/A
Eggs | 1.89 |  |  |  | #N/A
Stork | 2.1 |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 | #N/A |  |  |  | #N/A
 |  |  |  |  | #N/A
Spreadsheet: 686864d1594837898-cant-link-sequence-randarray-and-xlookup-together-link-functions
Sheet: Sheet1

 |  |  |  | 1 | [NAME]
 |  |  |  | 2 | Fred
 |  |  |  | 3 | [NAME]
 |  |  |  | 4 | [NAME]
 |  |  |  | 5 | [NAME]
 |  |  |  | 6 | Alfred
 |  |  |  | 7 | [NAME]
 |  |  |  | 8 | [NAME]
 |  |  |  | 9 | [NAME]
 |  |  |  | 10 | [NAME]
 |  |  |  | 11 | [NAME]
 |  |  |  | 12 | [NAME]
 |  |  |  | 13 | [NAME]
 |  |  |  | 14 | [NAME]
 |  |  |  | 15 | [NAME]
 |  |  |  | 16 | [NAME]
 |  |  |  | 17 | Alwyn
 |  |  |  | 18 | [NAME]
 |  |  |  | 19 | [NAME]
Spreadsheet: 797622d1664013123-formula-to-recalculate-lap-times-when-actual-times-vary-from-goal-times-lap-calculator
Sheet: Sheet1

 | Goal laps in 10 hrs | 60
 | 10
 | Lap target required | Actual lap time | New lap target
1 |  | 00:05:00
2 |  | 00:05:00
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