tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775838d1649344561-calculation-in-sum_range-of-sumif-example2
Sheet: Sheet1

id | p |  | id | p1 | p2
a | 0.2 |  | a
a | 0.8 |  | b
b | 0.3
b | 0.6 |  | I'd like p2 to be calculated by something like
 |  |  | =1-PRODIF(Table1[id];[@id];1-Table1[p])
Spreadsheet: 844827d1696497070-conditional-format-planning-file-cf-planning-aligw
Sheet: Example

 | Example
 | TO DO |  |  |  | 2023-09-01 00:00:00 |  |  |  | 2023-10-01 00:00:00 |  |  |  | 2023-11-01 00:00:00 |  |  |  |  | 2023-12-01 00:00:00 |  |  |  | 2024-01-01 00:00:00 |  |  |  |  | 2024-02-01 00:00:00 |  |  |  | 2024-03-24 00:00:00 |  |  |  | 2024-04-01 00:00:00 |  |  |  | 2024-05-01 00:00:00 |  |  |  |  | 2024-06-01 00:00:00
 | /!\ | [NAME] | Final Deadline |  | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 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
 |  | Delivierable 1 | 49
 |  | Delivierable 2 | 51
 |  | Delivierable 3 | 52
 |  | Delivierable 4 | 3
 |  | Delivierable 5 | 4
 |  | Delivierable 6 | 6
 |  | Delivierable 7 | 8
 |  | Delivierable 8 | 8
 |  | Delivierable 9 | 9
 |  | Delivierable 10 | 10
 |  | Delivierable 11 | 10
 |  | Delivierable 12 | 11
Spreadsheet: 736954d1623963428-using-another-cell-value-to-create-and-display-a-named-range-in-another-set-of-cells-example-file-tms
Sheet: Data

 | Function to allow dynamic named range
 | Heading but also named range ref | Selection_1 | Selection_2 | Selection_3 | Selection_4
 | Component lists | Part 1 | Part 6 | Part 14 | Part 21
 |  | Part 2 | Part 7 | Part 15 | Part 22
 |  | Part 3 | Part 8 | Part 16 | Part 23
 |  | Part 4 | Part 9 | Part 17 | Part 24
 |  | Part 5 | Part 10 | Part 18
 |  |  | Part 11 | Part 19
 |  |  | Part 12 | Part 20
 |  |  | Part 13
Spreadsheet: 706521d1606754388-formula-sum-and-multiplying-dynamic-array-spilled-behavior-dynamic-array
Sheet: Calculation

Product | Price | Volume | Revenue
 | 1 | 10
b | 2 | 20
c | 3 | 30
d | 4 | 40
Sum
Spreadsheet: 121656d1316223644-trouble-with-sumif-from-multiple-columns-budget-template-sample-2
Sheet: Sheet1

Income |  |  |  |  | Bank Balances |  |  |  |  |  |  |  | Internal transfers
Type | Date | Account | Amount |  | Acc |  | Opening 01/10 |  | Live Balance | Closing 31/10 | [NAME] (-+) |  | From |  | Date | Amount | To
Salary 1 | 2011-11-10 00:00:00 | Acc 123456 | 1020 |  | Acc 123456 |  | 1712.57 |  |  |  |  |  | Acc 123456 |  | 13/10 | 185 | Acc 1212121
 | 25/10 | Acc 123456 | 1150 |  | Acc 1212121 |  | 1800 |  |  |  |  |  | Acc 123456 |  | 27/10 | 185 | Acc 1212121
Wages 2 | 2011-01-10 00:00:00 | Acc 1212121 | 989 |  | Acc 4141414 |  | 10000
 | 17/10 | Acc 1212121 | 759
Jobs - other | 2011-10-10 00:00:00 | Acc 123456 | 100
 |  | TOTAL
Expenditure - Scheduled |  |  |  |  | Expenditure - Unscheduled
Scheduled | Date | Account | Amount |  | D/A | Type | Date | Account | Amount | Tax Deductible | % of budget remain
Mortgage 1 | 13/10 | Acc 123456 | 1020 |  | A | Petrol |  | Acc 123456 | 55 | No
 | 27/10 | Acc 123456 | 1050 |  |  |  |  | Acc 123456 | 78 | No
Mortgage 2 | 13/10 | Acc 1212121 | 1000 |  |  |  |  | Acc 123456 | 55 | No
 | 27/10 | Acc 1212121 | 1000 |  |  |  |  | Acc 123456 | 1.5 | No
Mortgage 3 | 2011-05-10 00:00:00 | Acc 4141414 | 1050 |  |  |  |  | Acc 1212121 | 20
Electricity | 13/10 | Acc 123456 | 50 |  |  |  |  | Acc 123456 | 32
 | 27/10 | Acc 123456 | 50
Phone - 1 | 13/10 | Acc 123456 | 80
 | 27/10 | Acc 123456 | 80
Phone -2 | 13/10 | Acc 123456 | 20
 | 27/10 | Acc 123456 | 20 | 20
Insurance |  |  | 50
 |  |  | 50
Health Insuranced | 13/10 | Acc 123456 | 40
 | 17/10 | Acc 123456 | 40
Swim lessons | 28/10 | Acc 123456 | 35
 |  | TOTAL
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: AMX 

S.No | DESCRIPTION | MODEL | Part no | SERIAL NO | QTY
I | AMX Exp 5231i [NAME] |  |  |  | 0
a | Modero Viwe point touch panel | MVP 5200-GP TouchPanel | FG-5966-01 | 596601X23A0010 | 0
b | Processor |  | FG-2105-04 | 21050X41A0021 | 1
c | AC Adoptor 3.5 Amp | PSN 4.4W | FG-423-45 | 42345AU3301011 | 1
d | HDMI Cable | CAT-5 | FG-10-051-10 |  | 1
e | CD |  | FG070-59 |  | 1
2 | AMX remote kit | MIO Modero R-4 |  |  | 1
4 | Signature Series Netlink Integrated Controller | NI-3101-SIG | FG2105-08 | 210508X18A0002, 0037,0048, 0047,0004 | 5
5 | Exp-Total-AVX400 | Exp-Total-AVX400-DC-UK, AVX-TO | FG1350-20K | 135001X21A0254, 0077,0120 | 3
6 | Distributed Audio/ Tango Audio Controller | DAS-TIIO808-SIG | FG1103-04 | 110304AP29A0032 | 1
7 | [NAME] for 5" Wall/Flush Mount Touch Panels | CB-TP5, [NAME] 5" wall conduct | FG038-10 | No number | 2
8 | Wall Plate | ALD-CW-1-Bl-Claro wall plate | FG2605-81-Bl | No number | 6
9 | Rough-in for 5.2” Modero ViewPoint Wall Charging Station | CB-MVP-WCS52 | FG037-11 | No number | 1
10 | AX LINK KeypadS | SP-08AX-UK-WH | FG1311-08KW | 131108KWP280007, 8 | 2
11 | WALL PlateS |  | FG1402-50KW | 140250KWP3890062, 28 | 2
12 | Total-214 | TPI-PRO-4-DVI | FG 2275-114- | 2275114X43A0040 | 1
13 | Transition Wall Plates |  | FG-1402-52KW | 140252kwp479008, 7 | 2
14 | Universal Transimittor Wall Plates | UPX-RGBA-UK-W | FG1402-51-KW | 140251KWP379004,13,6,7,66,67,57,18,23 | 9
15 | Power Cards | HDMI0UTPRO-0808-8RX Kit | FG 1047-88K | 104788AP49A0002 | 2BOX
16 | Modero Viwe point touch panel | MVP 500i-GB Touch panel | FG-5966-01 | 596601X23A0038 | 1
17 |  | AC Adaptor | FG423-45 | 42345AU2203455,199, 00624, 3392736,29, 3337119 | 3
18 |  | MVP-KS Stand touch channel | FG5965-12 | [NAME], 8109 | 2
19 | IR Emitter cables | CC-NIRC, IR-Emitter cables | FG 10-000-11 |  | 7
20 |  | MET-6N-BL Remotes | FG 5794-01BL | 579401BLX40A0042/579401BLX33A0014/579401BLX50A008/579401BLX40A0052/579401BLX40A0036/ 579401BLX40A0022,24A0004,0058,0028,0065,0061, 22A0048 | 12
22 |  | DVX 2100 HD SP Controller | FG 1905-01 | 190501X4690042 | 1
23 | Switcher kit | HDMI0UTPRO-0808-8RX Kit | FG1403 |  | 1
a | power adoptors |  |  |  | 3
b | power cards |  |  |  | 10
c | wall plates | NXD-5001 | FG-2261-02 | 22610x29A0121, 125 | 2
d | keypads | NXA-BEZ-5001-BL | FG-2261-34 |  | 2
e | Rough for  MVP-WDS WALL DOCKING Station | CB-MVP-WDS | FG037-10 |  | 1
f | Tango Audio Controller | DAS-T0804/8-SIG | FG1103-02 | 110302AP11A0018 | 1
e | AMX ROTER | NXA-WAP250G | FG2255-50 | 225550AC22A0154 | 0
24 | AMX 5231-I EXP KIT |  |  |  | 1
a | TOUCH PANEL | 500i-MVP |  | 596601X22A0096 | 1
b | Processor | NI-3100-SIG | FG2105-05 | 210505X4890110 | 0
c | ROTER | NXA-WAP250G | FG2255-50 | 2250AC0600541 | 1
27 | Digital DVI |  | FGP46-0808-DDO | 460808DD0AP51A0001 | 1
 | BACK
Spreadsheet: 600512d1543816729-sum-multiple-index-match-formulas-book1-3-
Sheet: Sheet2

 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48
Row 29
Row 30
Row 31
Row 32
Sum By Week
Spreadsheet: 147488d1332818169-can-cells-have-the-bkground-color-changed-upon-selection-of-an-item-from-a-drop-down-list-postable-data-production-schedule-evening
Sheet: Data Production Night Staff

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
MANAGER
MANAGER
MANAGER
MANAGER
Senior NAV 1
Senior NAV 2
Senior Mon + 1
Senior Mon + 2
Senior Mon + 3
Senior Mon + 4
Senior Mon + 5
Senior Mon + 6
Senior Mon + 7
Senior Mon + 8
Senior (Repeats)
Mon + 1 (R-SENIOR)
Mon + 2 (Regionals)
Mon + 3 (Regionals)
Mon + 4 (Regionals)
Mon + 5 (Regionals)
Mon + 6 (Regionals)
Mon + 7 (Regionals)
Mon + 8 (Regionals)
Mon + 9 (Regionals)
Mon + 10 (Regionals)
Mon + 1
Mon + 2
Mon + 3
Mon + 4
Mon + 5
Mon + 6
Mon + 7
Mon + 8
Mon + 9
Mon + 10
Mon + 11
Mon + 12
Mon + 13
Mon + 14
Mon + 15
Mon + 16
Mon + 17
Spreadsheet: daren_farmer__5294__LAphonelist
Sheet: Sheet1

Volume Management-On System
Name: | Phone# | Location
Bhavsar, Daxa | [PHONE] | LA 1510E
Brooks, Willie | NO PHONE | LA 1510F
[NAME], [NAME] | [PHONE] | LA 1510I
Camp, [NAME] | [PHONE] | LA 1510B
Comello, Mary | [PHONE] | LA 1512A
Fisher, [NAME] | [PHONE] | LA 1513A
Mitchell, [NAME] | [PHONE] | LA 1510C
[NAME], Thu | [PHONE] | LA 1511B
[NAME], [NAME] | [PHONE] | LA 1512B
[NAME], [NAME] | [PHONE] | LA 1510G
Vaugh, [NAME] | [PHONE] | LA 1511A
Viltz, [NAME] | [PHONE] | LA 1510D
Vogler, [NAME] | [PHONE] | LA 1510H
Fax : [PHONE]
Printer: Jupiter
Settlements- On System
Name: | Phone# | Location
Couvillon, [NAME] | [PHONE] | LA 1562B
Griffin, Rebecca | [PHONE] | LA 1526B
Hakemack, [NAME] | [PHONE] | LA 1525C
Herrera, [NAME] | [PHONE] | LA 1527B
[NAME], [NAME] | [PHONE] | LA 1525A
Ngo, [NAME] | [PHONE] | LA 1527A
Parker, Megan | [PHONE] | LA 1526A
Peebles, [NAME] | [PHONE] | LA 1524A
[NAME], Tess | [PHONE] | LA 1524B
Richmond, [NAME] | [PHONE] | LA 1525B
[NAME], Yolanda | [PHONE] | LA 1562A
Spreadsheet: 552633d1513697075-compounding-formula-that-only-compounds-at-a-whole-number-copy-of-usitech-compound-speadsheet-demo-start
Sheet: Sheet1

Make sure that all of the corresponding info in ORANGE (3) is correct prior to investing. Ensure that all data in row 3 is filled in. Investing is a risk and you should never invest more than you are willing to lose.
 |  |  | Start amount |  | Enter average interest rate (%): |  | Enter starting date: (it will show up as "####" SEE cell C8) |  | Reinvestment % |  |  |  |  |  |  | Price Of BTC
 |  |  | 1 |  | 1.4 |  | 43080 |  | 100 |  | https://hambone155.usitech-int.com |  |  |  |  | 19030
 | See Sheet two for more oppertunities withing the Bitcoin community. |  |  |  |  |  |  |  |  |  | Click here ^^^^^^^^^^^^^^^^^^ Click here
 | Term | Date (Start) | Investment Amount | x | Interest Rate + Bonus (not shown) | = | Term Interest (packs) |  | Lending Wallet accumulation (PACKS) | - | Reinvest (packs) | = | Amount left after reinvest |  | Carry the 1
 | 1 |  |  | x |  | =
 | 2 |  |  | x |  | =
 | 3 |  |  | x |  | =
 | 4 |  |  | x |  | =
 | 5 |  |  | x |  | =
 | 6 |  |  | x |  | =
 | 7 |  |  | x |  | =
 | 8 |  |  | x |  | =
 | 9 |  |  | x |  | =
 | 10 |  |  | x |  | =
 | 11 |  |  | x |  | =
 | 12 |  |  | x |  | =
 | 13 |  |  | x |  | =
 | 14 |  |  | x |  | =
 | 15 |  |  | x |  | =
 | 16 |  |  | x |  | =
 | 17 |  |  | x |  | =
 | 18 |  |  | x |  | =
 | 19 |  |  | x |  | =
 | 20 |  |  | x |  | =
 | 21 |  |  | x |  | =
 | 22 |  |  | x |  | =
 | 23 |  |  | x |  | =
 | 24 |  |  | x |  | =
 | 25 |  |  | x |  | =
 | 26 |  |  | x |  | =
 |  |  | BTC |  |  |  |  |  | This is to demonstrate 1 pack over the course of 10 years. The terms of 260 per year
 |  |  |  |  |  |  |  |  | 140 days per cycle with 100 working days.
 |  |  | BTC Value Currnet rate 10 years from now |  |  |  |  |  | https://hambone155.usitech-int.com
 |  |  |  |  |  |  |  |  | initial BTC investment
 |  |  | BTC Valute at propsed rate in 10 years |  |  |  |  |  | 0.0050346 | << | FILL THIS IN
Spreadsheet: 74482d1274974136-sorting-data-and-moving-data-using-advanced-filter-autofilter-example
Sheet: Q1303

 | Cost Centre Code: |  | Q1303
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 301 | 5001 | [NAME] | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 3 | 100 | Robins | A
Q1303 | 302 | 5002 | Wrathall Tim | 2010-05-05 00:00:00 | 2010-05-12 00:00:00 | 2 | 50 | [NAME] | A
Q1303 | 301 | 5001 | [NAME] | 2010-04-03 00:00:00 | 2010-05-03 00:00:00 | 5 | 100 | Robins | A
Q1303 | 304 | 5003 | [NAME] | 2010-02-02 00:00:00 | 2010-04-04 00:00:00 | 2 | 10 | Bus | B
Q1303 | 302 | 5005 | [NAME] | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2 | 44 | Beach Club | B
Q1303 | 301 | 5001 | [NAME] | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | 4 | 150 | Robins | B
Q1303 | 304 | 5006 | [NAME] | 2010-04-30 00:00:00 | 2011-04-01 00:00:00 | 1 | 10 | Taxi | A
Activity Code
301
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 301 | 5001 | [NAME] | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 3 | 100 | Robins | A
Q1303 | 301 | 5001 | [NAME] | 2010-04-03 00:00:00 | 2010-05-03 00:00:00 | 5 | 100 | Robins | A
Q1303 | 301 | 5001 | [NAME] | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | 4 | 150 | Robins | B
Spreadsheet: f740e017-5aa0-4554-bbc8-8665a3d6b6b1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPTWG | Test | FPTWG | Potato White IgG | Potato White IgG | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL  The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPTWG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPTWG | Result | FPTWG | Potato White IgG | Potato White IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 128827d1321298937-find-duplicates-using-vba-sameabove
Sheet: Sheet1

Letter |  | Helper
C |  | 1 | <<Another Non VBA method to get answer
B |  | 1
A |  | 1
A |  | 2
C |  | 2
C |  | 3
C |  | 4
D |  | 1
B |  | 2
B |  | 3
C |  | 5
Spreadsheet: 175537d1345562652-averaging-wind-directions-wind-direction-test
Sheet: Sheet2

2005-01-01 00:00:00
Spreadsheet: 9bca5406-f687-444c-af3e-20471cb3c14a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GRAS1 | Test | GRAS1 | Grass Panel # 1 | Grass Panel # 1 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel				 Specimen Volume: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRAS1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRAS1 | Result | GRAS1 | Grass Panel # 1 | Grass Panel # 1 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30189-5
Spreadsheet: 05e56417-072a-4b98-b999-b4900085a75a
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15a. MERCHANDISE EXPORTS, State and Australia, FOB Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829245L | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829246R | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829247T | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829248V | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829249W | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829250F | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829251J | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829252K | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A1829253L | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Re-exports ; |  |  | Original | A1829254R | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Total (State of origin) ; |  |  | Original | A1829255T | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 53153d1253085768-changing-cell-colour-on-certain-conditions-quote-to-invoice-log
Sheet: Sheet1

HALTON PANELCRAFT/MANTEC QUOTE TO INVOICE LOG
Job No. | Date | Customer | Contact | Qty | Description | Value | Quoted By |  | Order Date | Customer PO No. | Order Value | [NAME] | Delivery Note No. | Date | Invoice No.
1000 | 15.09.09 | A 2 Z Factory | [NAME] | 4 | S/S Panels | 300 | JR |  | 23.09.09 | AZ234567 | 300 | DP | 13564 | 28.09.09 | 15432
1001 | 15.09.09 | The Works | [NAME] | 2 | Enclosures | 250 | JR
1002 | 17.09.09 | The Works | [NAME] | 1 | Dosing Frame | 1500 | JR |  | 21.09.09 | NM 02341 | 1500 | DP | 13572 | 23.09.09 | 15440
1003 | 14.09.09 | A 2 Z Factory | [NAME] | 2 | Panels 200 x 200 x 1mm | 400 | JR
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
Spreadsheet: 819550d1677577509-sum-fields-based-on-month-data-to-analysis
Sheet: Summary

 |  |  |  | By Month |  |  |  |  |  |  |  |  | YTD
 |  |  |  | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |  |  |  | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  | JAN | 1 |  |  | 2 | 3 | 3 |  |  |  | JAN | 1
 |  |  | FEB | 1 |  |  | 1 | 1 | 2 |  |  |  | FEB
 |  |  | MAR | 2 |  |  | 2 | 2 | 2 |  |  |  | MAR
 |  |  | APR | 0 |  |  | 1 | 3 | 3 | 0 |  |  | APR
 |  |  | MAY | 1 |  |  | 2 | 3 | 0 | 1 |  |  | MAY
 |  |  | [NAME] | 1 |  |  | 1 | 2 | 5 | 2 |  |  | [NAME]
 |  |  | JULY | 1 |  |  | 1 | 3 | 0 | 2 |  |  | JULY
 |  |  | AUG | 0 |  |  | 1 | 1 | 1 | 2 |  |  | AUG
 |  |  | SEPT | 0 |  |  | 0 | 4 | 0 | 1 |  |  | SEPT
 |  |  | OCT | 2 |  |  | 1 | 2 | 3 | 3 |  |  | OCT
 |  |  | NOV | 1 |  |  | 1 | 2 | 0 | 0 |  |  | NOV
 |  |  | DEC | 1 |  |  | 0 | 1 | 4 |  |  |  | DEC
Spreadsheet: 842796d1694773897-problems-with-appending-columns-to-new-tables-combine_column
Sheet: CombinedSignals

Signal Type | Signal Name |  |  |  |  |  |  |  | Signal Type | Signal Name
 |  | But this is NOT how the Signal Name column should appear. |  |  |  |  |  |  | 28v_IN0 | ctrl_valve_interlk0 | This is how the Signal Name column should appear.
 |  |  |  |  |  |  |  |  | 28v_IN1 | ctrl_valve_interlk1
 |  |  |  |  |  |  |  |  | 28v_IN2
 |  |  |  |  |  |  |  |  | 5v_IN0 | lvl_sch0
 |  |  |  |  |  |  |  |  | 5v_IN1
 |  |  |  |  |  |  |  |  | Analog_IN0
 |  |  |  |  |  |  |  |  | Analog_IN1
 |  |  |  |  |  |  |  |  | Analog_IN2
 |  |  |  |  |  |  |  |  | 28v_OUT0 | ctrl_valve_pos0
 |  |  |  |  |  |  |  |  | 28v_OUT1 | ctrl_valve_pos1
 |  |  |  |  |  |  |  |  | 28v_OUT2
 |  |  |  |  |  |  |  |  | 5vOUT0 | eng_alm0
 |  |  |  |  |  |  |  |  | 5vOUT1
 |  |  |  |  |  |  |  |  | PWM_0
Spreadsheet: d5d09247-8cc0-4e84-b0af-4913ea191fe1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | ACL 2002 CONFERENCE - ASSUMPTIONS | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | revised 2/24/04
 |  |  |  |  |  |  | JDB
1. There are seven worksheets here, as follows:
1 | Assumptions
2 | Income-Expense Statement for ACL 2002 Conference
3 | Profit and Loss Statement by Event
4 | General Overhead list
5 | Calculations for distributing % of overhead among events
6 | Shadow account calculations
7 | Proportion of Income Generated by Specific Events
2. I am fairly confident in the attached results, however, the figures are only as good as the data I
received.
3. I have not been able to confirm the intent of Microsoft regarding the second donation of $5000.
By combining the notes of Trisha and [NAME], I decided to distribute the funds, $1000 to the
Lexical Acq. Workshop (W-10), $1000 toward Student Travel (Main), and the balance of $3000
to the ACL2003 Conference.
4. I have assigned 5% of the overhead staff expense to the cost of the banquet and 5% of the
overhead staff expense to the opening reception.
5. [NAME] expense has been charged directly to the main conference.
6. Balance of overhead distributed on basis of people/days per event, no adjustment made for
Irvine expense to main (so charges maximum amount to main conference.)
7. I have assigned the promotions, and various special event costs to the main conference, as
suggested by [NAME].
8. Workshop proceedings sales of $2,150 have been distributed among workshops on a
people/workshop basis.
9. Proceedings buy-backs by ACL have been deducted from specific event expenses.