tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Phoenix_P1

Phoenix Centralized Training ASC office
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME]
Phoenix | [NAME] | DOT only | FTM to RSA
Tucson
Mt. Vista | [NAME] | 71109160 | DSL Designate | Medium/Womens | 1/3 - 1/5 | Tue/Wed nights
 | [NAME] | 71107808 | Merchandiser | Medium/Women's | 1/3 - 1/5 | Tue/Wed Nights
 | [NAME] | 71110502 | RSA | XL | 1/3 - 1/5 | Tue/Wed Nights
 | [NAME] | 71110791 | RSA | L | 1/3 - 1/5 | Tue/Wed Nights
El Paso
Spreadsheet: 797559d1663954159-multi-value-look-up-to-fill-in-table-2022-09-23-oeldere-oporange-forum-help-sheet
Sheet: HELP

Kolom1 | Kolom2 | Kolom3 | Kolom4 | Kolom5 | Kolom6 | Kolom7 | Kolom8 | Kolom9 | Kolom10 | Kolom11 | Kolom12 | Kolom13 | Kolom14 | Kolom15 | Kolom16 | Kolom17 | Kolom18 | Kolom19 | Kolom20 | Kolom21 | Kolom22 | Kolom23 | Kolom24 | Kolom25 | Kolom26 | Kolom27 | Kolom28 | Kolom29 | Kolom30 | [NAME]
Date | 04-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022 | 08-2022 | 04-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022 | 04-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022 | 04-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022 | 04-2022 | 05-2022 | 06-2022 | 07-2022 | 08-2022
Employee | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Travis | Travis | Travis | Travis | Travis | Wayne | Wayne | Wayne | Wayne | Wayne | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
General | 175 | 11 | 102 | 198 | 4 | 171 | 113 | 157 | 7 | 70 | 194 | 32 | 169 | 203 | 178 | 59 | 20 | 159 | 89 | 181 | 9 | 132 | 179 | 134 | 108 | 149 | 181 | 177 | 38 | 4
Empty | 214 | 166 | 30 | 170 | 195 | 162 | 216 | 84 | 69 | 211 | 168 | 52 | 215 | 94 | 55 | 124 | 12 | 48 | 201 | 199 | 55 | 96 | 201 | 85 | 181 | 172 | 167 | 41 | 107 | 6
Omit | 79 | 24 | 77 | 155 | 182 | 84 | 198 | 78 | 27 | 42 | 206 | 98 | 155 | 184 | 89 | 193 | 202 | 117 | 92 | 197 | 218 | 101 | 96 | 162 | 42 | 163 | 114 | 100 | 44 | 107
Project Specific | 23 | 78 | 40 | 203 | 51 | 142 | 165 | 131 | 4 | 163 | 119 | 50 | 20 | 110 | 70 | 179 | 123 | 0 | 42 | 97 | 116 | 211 | 105 | 114 | 211 | 171 | 195 | 84 | 22 | 34
 |  | General | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00
 |  | [NAME]
 |  | [NAME]
 |  | Travis
 |  | Wayne
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 87147d1287019702-making-a-list-book2-1-
Sheet: Sheet1

MANAGER | EMPLOYEE
[NAME] | [NAME] | [NAME] | ChrisKader
[NAME] | Jake | Missy | [NAME]
Faye | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Select Manager:
 |  |  |  |  |  |  |  |  | Faye
Spreadsheet: 889153d1739880431-creating-a-graph-help-data-3-
Sheet: Summary

 | Yes / No %
 |  |  |  | Postal |  |  |  |  | Telephone |  |  |  |  | Web |  |  |  |  | Total
 |  | Period |  | Yes |  | No |  |  | Yes |  | No |  |  | Yes |  | No |  |  | Yes |  | No
 |  | Jan-24 |  | 2975 |  | 1114 |  |  | 12269 |  | 1826 |  |  | 9414 |  | 5269
 |  | Feb-24 |  | 3239 |  | 1357 |  |  | 10009 |  | 1468 |  |  | 7214 |  | 3694
 |  | Mar-24 |  | 4023 |  | 1567 |  |  | 10505 |  | 1519 |  |  | 8585 |  | 4480
 |  | Apr-24 |  | 1886 |  | 788 |  |  | 8166 |  | 1156 |  |  | 4932 |  | 1936
 |  | May-24 |  | 573 |  | 161 |  |  | 8186 |  | 1139 |  |  | 4275 |  | 1427
 |  | Jun-24 |  | 1006 |  | 473 |  |  | 7763 |  | 1091 |  |  | 5331 |  | 1795
 |  | Jul-24 |  | 467 |  | 234 |  |  | 8338 |  | 1177 |  |  | 3935 |  | 1601
 |  | Aug-24 |  | 611 |  | 330 |  |  | 8104 |  | 1101 |  |  | 4897 |  | 2740
 |  | Sep-24 |  | 423 |  | 284 |  |  | 8568 |  | 1305 |  |  | 5189 |  | 3162
 |  | Oct-24 |  | 584 |  | 357 |  |  | 9232 |  | 1334 |  |  | 6083 |  | 3825
 |  | Nov-24 |  | 1091 |  | 568 |  |  | 9583 |  | 1441 |  |  | 7171 |  | 4334
 |  | Dec-24 |  | 940 |  | 537 |  |  | 7126 |  | 1067 |  |  | 4654 |  | 3226
 |  | Jan-25 |  | 1843 |  | 1223 |  |  | 11974 |  | 1902 |  |  | 12316 |  | 8525
 |  | Feb-25 |  | 981 |  | 710 |  |  | 3412 |  | 526 |  |  | 2492 |  | 1683
 |  | Total
Spreadsheet: 748221d1631971725-assigning-additional-letters-for-duplicate-numbers-assigning-letters-to-duplicate-orders
Sheet: Sheet1

Orders | Orders
#1111a | #1111
#1111b | #1111 |  | #1111b
#2222 | #2222 |  | #2222
#2223 | #2223 |  | #2223
#2224 | #2224 |  | #2224
#2225a | #2225 |  | #2225a
#2225b | #2225 |  | #2225b
#2225c | #2225 |  | #2225c
#3332 | #3332 |  | #3332
#3333 | #3333 |  | #3333
#3334a | #3334 |  | #3334a
#3334b | #3334 |  | #3334b
#3334c | #3334 |  | #3334c
#3334d | #3334 |  | #3334d
#3334e | #3334 |  | #3334e
#3335 | #3335 |  | #3335
Spreadsheet: 088f1b45-b37f-42d2-b5d3-7269b8a105f4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | SEIU Local 1000 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  | 1808 - 14th Street, Sacramento, CA  95814
 |  |  |  |  |  |  |  |  |  |  |  | Accounting Use Only
Name (print) |  |  |  |  | Phone Number |  |  |  | Date
Mailing Address |  |  |  |  |  | City |  |  | Zip Code
E-Mail Address
Date
Location
Time Depart
Time Return
Activity
Activity Code
 |  | LODGING |  | LODGING |  | LODGING |  | LODGING |  | LODGING
1.   Room
2.   Incidentals
 |  | MEALS |  | MEALS |  | MEALS |  | MEALS |  | MEALS
3.   Breakfast
4.   [NAME]
5.   Dinner |  |  |  |  |  |  |  |  |  |  |  | I hereby certify that this is a true statement of travel expenses incurred by me in accordance with the current travel expense policy of Local 1000 during the period of this claim, that all items shown were for official business of Local 1000, and that no expenses herein were received from or paid by any other source.
 |  | TRAVEL |  | TRAVEL |  | TRAVEL |  | TRAVEL |  | TRAVEL
6.   [NAME]
7.   Airporter
8.   Personal Car
9.   Parking
10. [NAME]
 |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Signature
11. [NAME]
12. Telephone |  |  |  |  |  |  |  |  |  |  |  | Title
13. Other (explain) |  |  |  |  |  |  |  |  |  |  |  | Total expense this page | 0
TOTAL |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Total attached pages
Date | Item # | Comment |  |  |  |  |  |  |  |  |  | Grand total expenses | 0
 |  |  |  |  |  |  |  |  |  |  |  | Less - Travel advances
 |  |  |  |  |  |  |  |  |  |  |  | Balance due to Employee
 |  |  |  |  |  |  |  |  |  |  |  | Balance due to SEIU | 0
 |  |  |  |  |  |  |  |  |  |  |  | APPROVED
SEIU Local 1000  /  Rev. 10/2009)                                                                  NOTE: 1 copy is sufficient.  Do not submit in triplicate.
Send claims to the address above, care of Accounting.              If there is a "Balance Due to SEIU", attach a check made out to SEIU Local 1000.
Spreadsheet: 416bcf76-ee02-4ab6-8a8c-42bd0f19959a
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
VERG | Test | VERG | Sweet Vernal Grass, IgE | Sweet Vernal Grass, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in 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
VERG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
VERG | Result | VERG | Sweet Vernal Grass, IgE | Sweet Vernal Grass, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6261-2 | Anthoxanthum odoratum Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 91588d1291287870-is-it-possible-to-combine-merge-images-assemply-images
Sheet: Sheet1

Inlet Option | Guard Option | Outlet Option | Assembly Images |  | Inlet Images |  |  |  | Guard Images |  |  |  |  |  |  | Outlet Images
None | None | None |  |  | None |  |  |  |  |  |  |  |  |  |  | None
None | None | CGA HT |  |  |  |  |  |  | None
None | None | F CGA
None | Armor | None
None | Armor | CGA HT
None | Armor | F CGA |  |  |  |  |  |  | Armor
CGA HT | None | None
CGA HT | None | CGA HT
CGA HT | None | F CGA
CGA HT | Armor | None
CGA HT | Armor | CGA HT
CGA HT | Armor | F CGA
F CGA | None | None |  |  | CGA HT |  |  |  |  |  |  |  |  |  |  | CGA HT
F CGA | None | CGA HT
F CGA | None | F CGA
F CGA | Armor | None
F CGA | Armor | CGA HT
F CGA | Armor | F CGA
 |  |  |  |  | F CGA |  |  |  |  |  |  |  |  |  |  | F CGA
Spreadsheet: 105362d1302728497-combining-multiple-cells-into-one-not-your-regular-concatenate-example
Sheet: Sheet1

[NAME] of master report spreadsheet
Customer | Invoice Number | Date | Total
Client A | 1 | Date | 16
Client A | 2 | Date | 10
Client A | 3 | Date | 13
Client A | 4 | Date | 28
Client A | 5 | Date | 30
Client A | 6 | Date | 50
Client A | 7 | Date | 64
Client B | 8 | Date | 70
Client B | 9 | Date | 85
Client B | 10 | Date | 90
Client B | 11 | Date | 108
Client C | 12 | Date | 110
Client C | 13 | Date | 130
Client C | 14 | Date | 133
Client C | 15 | Date | 150
Client C | 16 | Date | 160
Client C | 17 | Date | 170
Client C | 18 | Date | 189
Client C | 19 | Date | 190
Client C | 20 | Date | 210
Client D | 21 | Date | 220
Client D | 22 | Date | 230
Client D | 23 | Date | 253
Client D | 24 | Date | 288
Client D | 25 | Date | 325
Client D | 26 | Date | 364
Now - To avoid formatting issues when sending details of the outstanding invoices in the mail merge through word, I must now consolidate the above information into a single row per customer:
**Statement spreadsheet for merge **
Client A | 0001 0002 0003 0004 0005 0006 0007 | 16.00          10.00          13.00          28.00          30.00          50.00          64.00 | To include date of each invoice
Client B | 0008 0009 0010 0011 | 70.00          85.00          90.00       108.00 | To include date of each invoice
Client C | 0013 0014 0015 0016 0017 0018 0019 0020 | 110.00       130.00       133.00       150.00       160.00       170.00       189.00       190.00       210.00 | To include date of each invoice
Client D | 0021 0022 0023 0024 0025 0026 | 220.00       230.00       253.00       288.00       325.00       364.00 | To include date of each invoice
This enables me to send out the statement and keep the formatting, i.e. invoice number sits on the same line as corresponding amount and corresponding invoice date.
As you can imagine I have around 450 customers to contact each month and this can take all day.
Ideally I would like to enter a formula in the summary spreadsheet that will pick up the data from the master report and put it all into the summary sheet in the format above.
is this possible?
Spreadsheet: 97252d1296490789-odd-printer-behavior-copy
Sheet: Sheet1

(70841) (Parker Hannifin) Ti contact system for 18x36 Paddlewheel Plating Barrel (x1)
Part name | Size | Material | Where used, if not obvious | Qty. | Make | In Stock | Order
Assembly
Housing | 7/8" x 5" x 15-15/16" | Polypro |  | 2 | x
Cover, housing | 7/8" x 5" x 15-15/16" | Polypro |  | 2 | x
O-ring retaining tube | Ø1.600" od x 1.750" long | Polypro |  | 2 | x
Copper contact bar | 1/2" x 1-1/2" x 4" | Copper | inside housing assy | 2 | x
Round contact bar | Ø1" od x 45-15/32" long | Ti/CU | inside cyl shaft | 1 | x
Spacer | Ø1.389" od x 1.750" long | Polypro |  | 1 | x
Hub retainers (special) | Ø5-1/4" x 1/2" thick | polypro |  | 2 | x
Idleside housing retainer | 3/32" x 1-1/2" x 13-5/8" | Titanium |  | 1 | x
Gearside housing retainer | 3/32" x 1-1/2" x 12-7/8" | Titanium |  | 1 | x
Spring retainer with step | Ø1.562" x .312" | UHMW |  | 4 | x
Spring retainer without step | Ø1.562" x .250" | UHMW |  | 4 | x
2-214 O-ring | MCMCAR 9396K35 | Purch. |  | 16 |  |  | x
[NAME] | MCMCAR 1430K55 | Purch. | length as needed | 4 |  |  | x
Spring | I/O door | Titanium | at housing retainer | 4 |  | x
Flat washer | 5/16" | Titanium | at housing retainer | 4 |  | x
HHCS | 5/16-18 x 2-1/2" | Titanium |  | 4 |  | x
PHSMS | #10 x 1" | Titanium |  | 48 |  | x
U-bolt with hex nuts | MCMCAR 3043T92 | Purch. |  | 2 |  |  | x
4-0 cable | as needed | Copper |  | 2 |  | x
Spreadsheet: 161372d1339510169-making-a-numbered-list-and-inserting-blanks-excelexample6-12
Sheet: Sheet1

0004 | [NAME] |  | 0001
0014 | [NAME] |  | 0002
0017 | [NAME] |  | 0003
0012 | Mathers |  | 0004
0008 | Mescudi |  | 0005
0001 | West |  | 0006
 |  |  | 0007
 |  |  | 0008
 |  |  | 0009
 |  |  | 0010
 |  |  | 0011
 |  |  | 0012
 |  |  | 0013
 |  |  | 0014
 |  |  | 0015
 |  |  | 0016
 |  |  | 0017
 |  |  | 0018
 |  |  | 0019
 |  |  | 0020
 |  |  | 0021
 |  |  | 0022
 |  |  | 0023
 |  |  | 0024
 |  |  | 0025
Spreadsheet: 828387d1683466909-sort-function-or-any-ignoring-header-in-existing-let-function-dummy4
Sheet: Sheet1

Sheet | Sheet2 |  |  |  |  |  |  |  |  |  | Sheet | Sheet2
Group |  |  |  |  |  |  |  |  |  |  | Group
 |  |  |  |  |  |  |  |  |  |  | 3rd Sort-Custom | 2st Sort-ascending |  |  | 1st Sort-ascending
 |  |  |  |  |  |  |  |  | Require > |  | Header1 | Header2 | Header5 | Header6 | Header7 | Header8 | Header9 | Header11
 |  |  |  |  |  |  |  |  |  |  | Rose | Ravi | #Test1 | 0 | 0 | 2696 | King | 88
 |  |  |  |  |  |  |  |  |  |  | Lily | Ajit | #Test1 | 0 | Jurrasic Park@95% | ADFG | 0 | 66
 |  |  |  |  |  |  |  |  |  |  | Lily | Ajit | #Test1 | 0 | Titanic@99% | 64638 | 0 | 72
 |  |  |  |  |  |  |  |  |  |  | Jasmine | Ram | #Test1 | Desktop | 0 | 64638 | District | 47
 |  |  |  |  |  |  |  |  |  |  | Jasmine | [NAME] | #Test1 | Popy | [NAME] Winlet@80% | 126364 | Text1 | 2
 |  |  |  |  |  |  |  |  |  |  | Jasmine | Ram | #Test1 | Tesla | Madonna@60% | 126364 | [NAME] | 97
 |  |  |  |  |  |  |  |  |  |  | Jasmine | [NAME] | #Test1 | Poly | Madonna@60% | 895634 | Electro | 98
Spreadsheet: 109892d1306710424-monthly-rollup-of-data-5-28-11
Sheet: SO2 Sheet

CALCULATION OF TOTAL AVAILABLE INLET SULFUR AND SULFUR DIOXIDE EMISSIONS
(NOTE:  MAKE YOUR ENTRIES IN THE APPROPRIATE YELLOW BOXES)
(AFTER MAKING YOUR ENTRIES, DO A FILE PRINT OR CLICK ON THE PRINTER BUTTON)
(YOU MAY USE ONE OR MORE OF THE METHODS FOR CALCULATION)
METHOD 1:  NORMAL OPERATION: |  |  |  |  |  | 2011-05-28 00:00:00
SO2 Emissions |  |  | 0 | Hr | 0 | Day
Sulfur Produced |  | = | 0 | LT
METHOD 2: ESTIMATE SO2 EMISSIONS IF SO2 ANALYZER IS OUT OF SERVICE:
Sulfur Produced |  | = | 0 | LT
METHOD 3: ROUGH ESTIMATE OF INLET SULFUR AND SO2 EMISSIONS:
Inlet Gas Rate |  | = | 18350 | MCFD
Average Inlet H2S |  | = | 0 | PPM
Sulfur Produced |  | = | 0 | LT |  | =
CHUNCHULA TOTAL AVAILABLE INLET SULFUR AND SULFUR DIOXIDE EMISSIONS
Method 1:
SO Sulfur Emitted |  | = | 0 | lbs/hr sulphur |  | 0 | lbs/day | 0 | LT
TOTAL AVAILABLE SULFUR |  |  | 63171 |  | = | 0 | LONG TONS
Method 2:
Total Available Sulfur |  |  | = | 0 | LT | 0 | LT Emitted |  | 0 | LT/Day
SO2 EMISSIONS |  |  | = |  |  | 0 | LBS/HR SO2
Method 3:
Moles of Gas/Day |  | = | 48353.09617918314 | Moles Gas/Day |  | 0 | Moles of H2S |  | 0 | lbs Sulfur/Day
 |  | 0 | LT/Day Available |  |  | 0 | LT/Day Sulfur Emitted
SO2 EMISSIONS |  |  |  |  | = | 0 | LBS/HR SO2
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(PV) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(PV): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 20010-11
 | Major Group | PV - Pre-Veterinary
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | na | na | na | na
Graduates who completed remedial courses during their time at the TCU |  |  | na | na | na | na
Graduates who received A*CF support at some point during their coursework |  |  | na | na | na | na
Notes:
Spreadsheet: 102264d1300226549-random-item-number-equals-correct-price-new-job-template
Sheet: Deposit

INVOICE
For Customer: |  |  |  |  |  | From: |  | Terms | Deposit
Name: | 0 |  |  |  |  | LaMorinda Tile and Stone
Address: | 0 |  |  |  |  | 2261 Commerce Ave., Suite B
City: | 0 |  |  |  |  | Concord, CA 94520 |  | Work Order#
Phone: | 0 |  |  |  |  | [PHONE]
Fax: | 0 |  |  |  |  | [PHONE] |  | Date | 2011-03-15 00:00:00
Phase/Date |  | Description |  |  |  |  |  |  | Price
TOTAL DUE: |  |  |  |  |  |  |  |  | 0
We Appreciate Your Prompt Payment.
Spreadsheet: 103989d1301612936-two-if-statements-in-one-cell-returning-incorrect-results-issues-with-if-statement
Sheet: Sheet1

Condition | 0.0045 | 0.14
 | A | B
 | 0.02325559528 | 0.1604241293 | 0
 | 0.02149723674 | 0.12725786089 | 0
 | 0.01470232255 | 0.06983666055 | 0
 | 0.01070661223 | 0.04960222699 | 0
 | 0.00490387111 | 0.06076584585 | 0
 | 0.00481619367 | 0.04567176234 | 0
 | 0.47629675076 | 0.99446179505 | 0
 | 0.04457793297 | 0.13564532919 | 0
 | 0.00862652492 | 0.12274223559 | 0
 | 0.00459764366 | 0.0997597013 | 0
 | 0.18338065707 | 2.47481762469 | 0
 | 0.02921363271 | 0.57471635603 | 0
 | 0.00632515807 | 0.07872316872 | 0
 | 0.00585117843 | 0.05449679815 | 0
 | 0.0045092434 | 0.05564160432 | 0
 | 0.03968493262 | 0.05239624712 | 0
 | 0.03687434907 | 0.05673771895 | 0
 | 0.00821937924 | 0.04993982203 | 0
 | 0.00682659764 | 0.05994018525 | 0
 | 0.0060028042 | 0.09263221627 | 0
 | -0.01630816915 | 0.21600747414 | 1
 | -0.01980871875 | 0.17336905493 | 1
 | -0.01982630022 | 0.49030235854 | 1
 | -0.02089089367 | 0.28993452454 | 1
 | -0.02139317632 | 0.56913618637 | 1
 | -0.02328323834 | 0.23523189336 | 1
 | -0.02336571443 | 0.14538940875 | 1
 | -0.02410018338 | 0.1518978721 | 1
 | -0.0253194426 | 0.22120536092 | 1
 | -0.02764932554 | 0.24289482878 | 1
 | -0.02887324232 | 0.35682689104 | 1
 | -0.02915254815 | 0.17502929076 | 1
 | -0.0318108838 | 0.18941501729 | 1
 | -0.01203905812 | 0.10300926019 | 0
 | -0.01408156296 | 0.06890798614 | 0
 | -0.0142043508 | 0.05466766685 | 0
 | -0.01552718319 | 0.1375293449 | 0
 | -0.01749075016 | 0.06650396286 | 0
 | -0.01845337531 | 0.13364876811 | 0
 | -0.01892952098 | 0.09281724382 | 0
Spreadsheet: 684606d1593457372-formula-to-expand-retract-table-b-according-to-entry-actions-on-table-a-logged2
Sheet: TimeOut

TO # | Weekday | Date | Present | Dur1 | Dur2 | Dur3 | Dur4 | Dur5 | Dur6 | Dur7 | Dur8 | Dur9 | Dur10 |  |  | Date | Time Outs | Average
 |  | 2017-01-01 00:00:00 | No
 |  | 2017-01-02 00:00:00 | Yes | 34 | 47 | 56 | 22 | 11 | 6 | 33 | 53
 |  | 2017-01-03 00:00:00 | Yes | 26
 |  | 2017-01-04 00:00:00 | Yes | 34
 |  | 2017-01-05 00:00:00 | Yes | 22 | 25 | 27
 |  | 2017-01-06 00:00:00 | Yes | 15 | 21 | 31
 |  | 2017-01-07 00:00:00 | No
 |  | 2017-01-08 00:00:00 | No
 |  | 2017-01-09 00:00:00 | Yes | 32 | 23 | 10 | 24 | 23 | 34
 |  | 2017-01-10 00:00:00 | Yes | 23 | 25
 |  | 2017-01-11 00:00:00 | Yes | 34 | 56 | 34 | 21 | 24 | 36
 |  | 2017-01-12 00:00:00 | Yes | 22
 |  | 2017-01-13 00:00:00 | Yes | 24 | 30 | 26 | 14
 |  | 2017-01-14 00:00:00 | No
 |  | 2017-01-15 00:00:00 | No
 |  | 2017-01-16 00:00:00 | No
 |  | 2017-01-17 00:00:00 | Yes | 24 | 14 | 28 | 34 | 16 | 18 | 13 | 13
 |  | 2017-01-18 00:00:00 | Yes | 24
 |  | 2017-01-19 00:00:00 | Yes | 25 | 35
Spreadsheet: 85168d1285223209-divide-by-zero-errors-kitchen-replacement-programme-2010-11_revised_web_upload2
Sheet: General Prop Completion Calcs

 |  | Properties Instructed |  | Projected Spend
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs |  |  |  | Actual Property Completions |  | Actual Costs
 |  | Aug |  |  |  |  |  |  |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Sept
 |  | Oct |  |  |  |  |  |  |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Nov
 |  | Dec |  |  |  |  |  |  |  | Dec
 |  | Jan |  |  |  |  |  |  |  | Jan
 |  | Feb |  |  |  |  |  |  |  | Feb
 |  | Mar |  |  |  |  |  |  |  | Mar
 |  | Apr |  |  |  |  |  |  |  | Apr
 |  | May |  |  |  |  |  |  |  | May
 |  | Jun |  |  |  |  |  |  |  | Jun
 |  | All Properties |  | Projected Spend |  |  |  |  |  | Average Figures
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs
 |  |  |  |  |  |  |  |  |  | Initial Works Order Value
 |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Variations
 |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Final Works Order Value
 |  | Dec
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Over All Totals
 |  | Initial Works Order Value
 |  | Variations
 |  | Final Works Order Value
 |  | Projected Over Spend Based on Initial W/O Costs
 |  | Projected Total Av.
 |  | Over Spend
 |  | Misc
 |  | Projected Over Spend
 |  | Projected Over Spend Based on Final W/O costs
 |  | Projected Total Av.
 |  | Over Spend
 |  | Misc
 |  | Projected Over Spend
Spreadsheet: 148809d1333560590-filter-by-date-in-cell-book1-version-1-
Sheet: Sheet1

Client | Code | [NAME] | Freq2 | [NAME] | Fee to bill | Change | Currency | Partner | Last Invoice To Date | Start Date | To Date | When to Invoice |  | Last Invoice To Date | Last Invoice To Date
 |  | MAR | 31 | Monthly Arrears | 15000 | 0 | GBP |  | 29/02/2012 | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 |  | >=2/29/2012 | <=4/30/2012
 |  | MAD | -1 | Monthly Advance | 16000 | 0 | USD |  | 30/04/2012 | 2012-05-01 00:00:00 | 2012-05-31 00:00:00 | 2012-04-30 00:00:00
 |  | QAD | -1 | Quarterly Advance | 36000 | 0 | GBP |  | 23/06/2012 | 2012-06-24 00:00:00 | 2012-09-23 00:00:00 | 2012-06-23 00:00:00
 |  | QAD | -1 | Quarterly Advance | 15499.98 | -0.02000000000043656 | GBP |  | 13/04/2012 | 2012-04-14 00:00:00 | 2012-07-13 00:00:00 | 2012-04-13 00:00:00
 |  | MAR | 31 | Monthly Arrears | 10000 | 0 | GBP |  | 29/02/2012 | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00
 |  | MAD | -1 | Monthly Advance | 16500 | 0 | GBP |  | 14/04/2012 | 2012-04-15 00:00:00 | 2012-05-14 00:00:00 | 2012-04-14 00:00:00
 |  | QAD | -1 | Quarterly Advance | 15000 | 0 | GBP |  | 30/06/2012 | 2012-07-01 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00